Need Function Argument

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pasekm - 18 Mar 2006 21:37 GMT

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

Reply to this Message

RagDyeR - 18 Mar 2006 22:49 GMT

Enter this is B1 and copy down:

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

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

Signature

HTH,

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

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?

Signature

pasekm
------------------------------------------------------------------------
pasekm's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=32591
View this thread: http://www.excelforum.com/showthread.php?threadid=523952

Reply to this Message

Peo Sjoblom - 18 Mar 2006 22:49 GMT

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

Signature

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

> 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?

Reply to this Message

pasekm - 18 Mar 2006 23:16 GMT

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

Reply to this Message

RagDyeR - 19 Mar 2006 00:14 GMT

Then try this:

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

Signature

HTH,

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

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.

Signature

Reply to this Message