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?
Last edited by maryren; 09-25-2013 at 11:27 AM.
=INDIRECT(ADDRESS(MATCH(MIN(C:C),C:C,0),3))
Where 3 is the column you want returning to the cell you put the formula in.
Try this...
Sheet1
Sheet2
Enter this formula in A2 and copy across to C2:
=INDEX(Sheet1!A2:A4,MATCH(MIN(Sheet1!$B2:$B4),Sheet1!$B2:$B4,0))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks