Please help me in the following example:

I have a list of 100 figures in B1:B100. I want to insert a formula in
A1:A100 which results in showing the position of each number i.e. from 1 to
100 in the order of volume of corresponding figure in Column A.

In the end I insert:
1 to 20 (in C1:C20) and
=vlookup(C1,$A$1:$B$100,2,0)

In the end result in D1:D20 is the list of top 20 figures from the list
which updates on even a slight change in B1:B100.

Thanx

--

Best Regards,
FARAZ A. QURESHI