# Formula to find lowest/highest value in a column and return value to that cell

1. ## Formula to find lowest/highest value in a column and return value to that cell

I am looking to create a summary of just a few line items of data from a database. I tried using a pivot, but could not end up with the look I wanted. I'd like to be able to find the lowest or highest value of a cell in a column of information and return that row of information to the cell (ideally in another worksheet)

For example:
A 100 Within Tolerance
B 105 Within Tolerance
C 110 Outside Tolerance

The formula should return Line A to my summary worksheet
Any suggestions?

2. ## Re: Formula to find lowest/highest value in a column and return value to that cell

Where 3 is the column you want returning to the cell you put the formula in.

3. ## Re: Formula to find lowest/highest value in a column and return value to that cell

Try this...

Sheet1
 A B C 1 Part Reading Status 2 A 100 Within Tolerance 3 B 105 Within Tolerance 4 C 110 Outside Tolerance

Sheet2
 A B C 1 Part Reading Status 2 A 100 Within Tolerance

Enter this formula in A2 and copy across to C2:

=INDEX(Sheet1!A2:A4,MATCH(MIN(Sheet1!\$B2:\$B4),Sheet1!\$B2:\$B4,0))

4. ## Re: Formula to find lowest/highest value in a column and return value to that cell

This works, however, if I have multiple rows of A, with different tolerance levels, how should I alter the formula? i.e., returning the first row of information from the table below since it has the lowest number?

A 100 Within Tolerance
A 101 Within Tolerance
A 102 Within Tolerance
B 105 Within Tolerance

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1