excell worksheet function

  • Thread starter Thread starter D
  • Start date Start date
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel finding top of range 1
Showing the top result from a range of cells 6
Assign points based on two conditions 1
Excel "Worksheet Name" Building Function for Summary Sheet 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
INDEX and sum 1
sorting rows of data 7

Back
Top