Need Function Argument

P

pasekm

I have a spreasheet that contains 2 columns. Column A1 thru A1
contains various numbers. I want to set up an Argument in B1 asking i
A1 is the Unmatched Minimum Number in Column A. It true I want th
Argument to return the number 1. If False I want the Argument t
return Blank. I want to continue the Argument thru B10. Does anybod
know how to do this
 
R

RagDyeR

Enter this is B1 and copy down:

=IF(MIN($A$1:$A$10)=A1,1,"")

Don't understand your meaning of "Unmatched Minimum".

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


message
I have a spreasheet that contains 2 columns. Column A1 thru A10
contains various numbers. I want to set up an Argument in B1 asking if
A1 is the Unmatched Minimum Number in Column A. It true I want the
Argument to return the number 1. If False I want the Argument to
return Blank. I want to continue the Argument thru B10. Does anybody
know how to do this?
 
P

Peo Sjoblom

What does

"Unmatched Minimum Number in Column A" mean?

if you just mean the minimum, in B1 put

=IF(MIN($A$1:$A$10)=A1,1,"")

copy down to B10



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 
P

pasekm

Thanks for the Reply What I mean by Unmatched Minimum is only a singl
entery in A equals the Minimum or Lowest Amount. I want the Argumen
to return 1 when this happens. When multiple enteries equal the Min o
Lowest number I want the Argument to return blank
 
R

RagDyeR

Then try this:

=IF(AND(COUNTIF($A$1:$A$10,A1)=1,MIN($A$1:$A$10)=A1),1,"")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

message
Thanks for the Reply What I mean by Unmatched Minimum is only a single
entery in A equals the Minimum or Lowest Amount. I want the Argument
to return 1 when this happens. When multiple enteries equal the Min or
Lowest number I want the Argument to return blank.
 
Top