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

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/comm...lic.excel.misc

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

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


datarange wrote:
: 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/comm...lic.excel.misc

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

try
=ADDRESS(MATCH(MIN(A:A),A:A,0),1)

--
Don Guillett
SalesAid Software

"vandenberg p" wrote in message
...
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


datarange wrote:
: 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/comm...lic.excel.misc