excell worksheet function
 

how do I find the location of a particular item in a worksheet? For example,
if I have a spreadsheet showing the last 30 years of sales production how
could I find the cell location of the highest or lowest figure?

excell worksheet function
 

Use MATCH in conjunction with MIN or MAX to get the (relative) row, such as:

=MATCH(MAX(S1:S2000),S1:S2000,0)
=MATCH(MIN(S1:S2000),S1:S2000,0)

assuming sales figures are within the range S1:S2000.

Hope this helps.

Pete

"D" wrote in message
...
how do I find the location of a particular item in a worksheet? For
example,
if I have a spreadsheet showing the last 30 years of sales production how
could I find the cell location of the highest or lowest figure?