Re: Looking for something similiar to MIN

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"Steve Haack" <SteveHaack@xxxxxxxxxxxxxxxxxxxxxxxxx>ha scritto nel messaggio
D568F599-B740-43EA-8B9B-07EB76BA80FF@xxxxxxxxxxxxx

> I am looking for a MIN function that will tell me the smallest number
> in a column of numbers, but only if it is unique. For example, if the
> column has 2 instances of the number 5, and it is the smallest, then
> I don't care, but if there is only one instance, then I want to know
> about it. Ideally, it would return the cell that it is in, rather
> than just the number.
>
> Anybody know of something like that?
>
> Thanks,
> Steve

If I have well understood you need a formula like this:

=IF(AND(A1=MIN(Your_Range),COUNTIF(Your_Range,A1)=1),A1,0)

Copy this formula in cell B1 (I suppose your data start at A1) and then copy
down till the lenght of your list.
Then you can use AutoFilter to search your value.

Hoping to be helpful...

Regards
--
Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------


.

Relevant Pages