F
Fanny
Dear Friends,
I need to find the smallest 8 amounts from hundreds of data and look up the
data of the corresponding amount. So I used the small function with
referrence to the Rank column and found two -100,000.00 and each of them
related to Joey and Keith. However, the vlookup function retrieved both data
as Joey and lost Keith's Number and Name. Same problem occurs if retrieving
the top 10 amounts with large function.
Thanks for your great help in advance.
Fanny
Rank Amount Number Name
1 -156,250.00 8 John
2 -120,547.00 13 Peter
3 -103,100.00 541 Mary
4 -102,227.00 20 Kary
5 -100,000.00 261 Joey
6 -100,000.00 261 Joey
7 -87,192.00 1 Kelvin
8 -77,250.00 92 Josephe
I need to find the smallest 8 amounts from hundreds of data and look up the
data of the corresponding amount. So I used the small function with
referrence to the Rank column and found two -100,000.00 and each of them
related to Joey and Keith. However, the vlookup function retrieved both data
as Joey and lost Keith's Number and Name. Same problem occurs if retrieving
the top 10 amounts with large function.
Thanks for your great help in advance.
Fanny
Rank Amount Number Name
1 -156,250.00 8 John
2 -120,547.00 13 Peter
3 -103,100.00 541 Mary
4 -102,227.00 20 Kary
5 -100,000.00 261 Joey
6 -100,000.00 261 Joey
7 -87,192.00 1 Kelvin
8 -77,250.00 92 Josephe