software

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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc

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:
=quot;Aquot;amp;MATCH(MIN(A1:A5),A1:A5,0)
Which will display a value of A3

Pieter Vandenbergdatarange gt; 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 quot;I
: Agreequot; 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 quot;I Agreequot; in the message pane.

: www.microsoft.com/office/comm...lic.excel.misc

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

--
Don Guillett
SalesAid Software

quot;vandenberg pquot; gt; wrote in message
...
gt; Hello:
gt;
gt;
gt; Given the following sequence of numbers in column A, rows 1 to 5
gt; 3
gt; 4
gt; 1
gt; 2
gt; 3
gt; The following will return the row number of the minimum value:
gt; =MATCH(MIN(A1:A5),A1:A5,0)
gt; Which will display a value of 3 (3rd row)
gt;
gt; You can convert this in to a complete cell address if you want by:
gt; =quot;Aquot;amp;MATCH(MIN(A1:A5),A1:A5,0)
gt; Which will display a value of A3
gt;
gt; Pieter Vandenberg
gt;
gt;
gt; datarange gt; wrote:
gt; : when the range is selected within the data for having minimum value in
gt; the
gt; : field ,
gt; : how to report where is this minimum value in the given range.
gt;
gt; : ----------------
gt; : This post is a suggestion for Microsoft, and Microsoft responds to the
gt; : suggestions with the most votes. To vote for this suggestion, click the
gt; quot;I
gt; : Agreequot; button in the message pane. If you do not see the button, follow
gt; this
gt; : link to open the suggestion in the Microsoft Web-based Newsreader and
gt; then
gt; : click quot;I Agreequot; in the message pane.
gt;
gt; :
gt; www.microsoft.com/office/comm...lic.excel.misc