"via135" wrote:
... more than 20000 records it seems
to be take a very long time for the application of the formulae!
is there any other simpler method for picking
the desired top valued items ?

Try this:

Copy only col C's formula all the way down to row20000 (this is required)
Then copy A2:B2 down only as far as required to extract the desired top
values, eg: to retrieve top 20, copy down to say B25, check the evaluated
results, then copy down a few more lines if required (if there are ties).

Set the calc mode to Manual.
Do the formula fills, then press F9 to recalc.
If you've got the results that you want, kill all formulas,
then re-set calc mode back to Auto.

.. when the amount in the list equals "0" COL"C" throws some error,
like the one, while entering more than 15 digits in a cell formarted
general.

Col C is the arb tiebreaker. You can minimize or hide the col away.
Ensure that only real numbers are entered under the "Amt" col
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---