Excel should have when.. if, where..if,if..then..else with range

D

datarange

when the range is selected within the data for having minimum value in the
field ,
how to report where is this minimum value in the given range.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...5-ad2d619731f3&dg=microsoft.public.excel.misc
 
V

vandenberg p

Hello:


Given the following sequence of numbers in column A, rows 1 to 5
3
4
1
2
3
The following will return the row number of the minimum value:
=MATCH(MIN(A1:A5),A1:A5,0)
Which will display a value of 3 (3rd row)

You can convert this in to a complete cell address if you want by:
="A"&MATCH(MIN(A1:A5),A1:A5,0)
Which will display a value of A3

Pieter Vandenberg


: when the range is selected within the data for having minimum value in the
: field ,
: how to report where is this minimum value in the given range.

: ----------------
: This post is a suggestion for Microsoft, and Microsoft responds to the
: suggestions with the most votes. To vote for this suggestion, click the "I
: Agree" button in the message pane. If you do not see the button, follow this
: link to open the suggestion in the Microsoft Web-based Newsreader and then
: click "I Agree" in the message pane.

: http://www.microsoft.com/office/com...5-ad2d619731f3&dg=microsoft.public.excel.misc
 
Top