Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
define one cell location throughout workbook? | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Reference Cell if Found in a IF function | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions |