More MIN() results..?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Having several columns of values and under each its MIN cell, if there are
more (like the minimum value for a column is 12 and it appears in 10 rows out
of 200), how do I go about showing each of them with its respective row
number in the MIN() result?
 
You could maybe use

=ADDRESS(MATCH(MIN(A1:A200),A1:A200,0),COLUMN())

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top