Thread: Identifying the lowest number in a row.

I'm trying to form a formula to write in a the row with the lowest number. The formula would appear in column 2 (the "Lowest" column)

E.g
A B
2
1 "Lowest"
3


If the lowest number appears more than once in the list, the formula should return "Lowest" once, but doesn't matter which row it appears in.

Thanks

Perhaps:

B1:
=REPT("Lowest",ROW(A1)=MATCH(MIN(A:A),A:A,0))
copied down

Try this in B2

=IF(ROW()=MATCH(MIN(A:A),A:A,0),"Lowest","")

Drag/Fill Down

This should return the first minimum value found