Home |
Search |
Today's Posts |
#1
|
|||
|
|||
find and match the max
i have two tables and (quick recap - i want to find out the highest bid and the second highest bid - i haven't thought about if there is more than one high bid) Lot Number: Highest Amount Second Highest User A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12 A13 A14 Lot Number Amount User A1 2.66 User 6 A1 3 User 5 A1 3.56 User 1 A1 3 User 3 A0 3 User 4 A1 1 User 5 A1 2 User 1 A1 3 User 3 A10 2 User 4 A10 3 User 5 A11 2 User 1 A11 3 User 3 A12 2 User 4 A12 3 User 5 -- buffyslay ------------------------------------------------------------------------ buffyslay's Profile: http://www.excelforum.com/member.php...fo&userid=3573 View this thread: http://www.excelforum.com/showthread...hreadid=274473 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
find and match the max | Excel Worksheet Functions | |||
find and match the max | Excel Worksheet Functions | |||
Need find cell b3 value on another worksheet! | Excel Worksheet Functions | |||
Use MATCH to find position of max in 2D range? | Excel Worksheet Functions |