LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
define one cell location throughout workbook? New_to_accounting Excel Worksheet Functions 3 September 2nd 06 12:36 AM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Reference Cell if Found in a IF function A Stevens Excel Worksheet Functions 2 December 25th 05 05:27 PM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM


All times are GMT +1. The time now is 06:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"