excell worksheet function

D

D

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?
 
P

Pete_UK

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
 
Top