| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find max and return corresponding value
Hi all, I am a new member to this forum. I have an excel problem and I hope all the experts in here can help me out.
A,B,C Diameter,thickness,ID 762,25.4,1324 762,25.4,1325 660,19,1496 660,15.9,5000 762,35,1462 762,35,1464 Note: column separated by comma (,) From the list, I would like to get two corresponding ID that would give the max diameter with the corresponding max thickness. For example first answer will be max diameter is (762) corresponding max thickness is (35) and ID (1462). second answer will be max diameter is (762) corresponding max thickness is (35) and ID (1464). Thanks.. Last edited by akhdiad : March 13th 12 at 03:07 AM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and return a value | Excel Worksheet Functions | |||
| Find and Return | Excel Discussion (Misc queries) | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| find & return value | Excel Discussion (Misc queries) | |||
| what does .Find return | Excel Programming | |||
Threaded Mode
