Find Toppers of each unique code in a column

Dear Friends,

I have some 8000 rows of data consists of a survey.

I need to find out TOPPERS of each SUB_CODE which are available in a single column.

I have clearly mentioned the problem and the solution required in the attached workbook.

I hope someone will help me to solve this.

Thanks in advance,

acsishere.

Try this macro

It sorts data in column A to G
extracts toppers to column K to Q
Resorts column A to G back to original sort

Code will not work correctly if each Sub Code does not have at least 2 Sub Cat categorys - Do they all have more than 1?

Please Login or Register  to view this content.

Thanks for the code.

But, when I checked with the sample data, it finds 2 toppers in each code. Whereas, In my data some codes may have only one topper, or some codes may have 2 toppers, or some other codes may have three or more.

The above code finds only two toppers of each code.

Besides, I don't want to sort the data. Without sorting is it possible?

Once again I have attached the worksheet along with the above code tested in it (in SHEET4). I have explained the difficulty also in it.

Thanks in advance.

Yours, acsishere.

You might want to specify exactly what a Topper is? What determines what makes it as a Topper and what does not?

I think I understand what ou want this time

I originally thought you want the top points listed by Sub Code & Sub Cat, not just the top points by Sub Code


I sort the data because it is the easiest way to pickup the highest and multiple equal points per Sub Code.
The data is restored to its un sorted state before the macro was run

Please Login or Register  to view this content.

If the use of the sort is causing a problem please explain what problem it is causing

It is possible to get them without sorting, but it would take a lot more coding as the macro would need to keep track of the top scores for each Sub_Code and compare them to each entry on the spread sheet

Using Sort is much quicker & easier & blank cells can taken into account



I have added a command to ignore any row that does not have an entry in column D

I inserted some blank rows into your posted example workbook and the code
worked ok.

Please Login or Register  to view this content.