auto identify top 25 values from a column x

[hudson andrew]

Hi all,

I was wondering if some one would help me coding top 25 values from the column B and place it in column c .

I was doing it old fashioned way by filtering ... rather I want that in VBA program.

attached is the example file for your reference .

thanks & regards,
Hudson

[JBeaucaire]

You don't need VBA, nor do you need to sort the raw data A:B. Even if A:B was randomized, this formula will work in realtime, put in C2 and copy down for 25 values:

=LARGE(B:B, ROW(A1))

[JieJenn]

Give this a try. You use CallTopN procedure to specify the number of top values you want to retrieve.

Please Login or Register  to view this content.

[hudson andrew]

thanks all for your advice on my question . however I was wondering if there is something can be done the same way I have attached. after my top 25th value cells in " C " should go blank and I want only my top 25 values in C nothing else . that should also work even my data is Random . in column " B ".....