Dear all,
ScreenHunter_003.jpg
1. Lookup the largest value from G5:G8 (89)
2. Lookup the relative range from Col E (<=10)
3. Find out the first 2 names with values in this range. (Alice & Tom)
4. Put the result on I5:J6.
5. Repeat similar procedure for the 2nd large value from G5:G8 (65)
6. Put the result on I7:J8.
What are the formula in I5:J8 then?
Thanks
Bookmarks