View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dallman Ross Dallman Ross is offline
external usenet poster
 
Posts: 390
Default How to know location of cell found with MIN/MAX?

I'm wondering if it's possible (and easy) to query a result
to find out the cell's location when using MIN or MAX.

E.g.:

A
---
1 120
2 343
3 32
4 934
5 36
6 32
7 661

I believe MIN will find A6, even though A3 is also the same minimum
value. Hmm, actually I'm not sure about that. But anyway, the value
found may not be unique. I'd like to know one of them in the range;
I don't really care which. E.g., A3 or A6. Can I surround the MIN
statement with some other formula that will tell me the (an)
address of the result?

I don't want to use MATCH, because, for one, this is on filtered
data, yet if my value (such as 32) appears in the unfiltered part
of the table I'll have a false answer. Or is there a way to
combine MATCH and filtered data that I'm not seeing?

Dallman Ross