Data Sort

[stealthtrooper]

I have a table with three columns

Name, Country and score

The name and score are entered by the user and the country selected from a set drop down list.

Once all the data is entered, I would like is be able to set a macro or formula to display or highlight just the top two results for each country. I just can't figure it out - any help would be appreciated.

Thanks
Paul

[mrice]

Try this

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.

[stealthtrooper]

Thanks - unfortunately I'm getting an error code -Run-time Error '9': subscriptout of range

It seems to highlight the top two for afghanistan (first on list) but finishes with the error code.

Thanks
Paul

[mrice]

Try this - the error might be caused by a country which has only one entry. If this doesn't work, please post some sample data

Please Login or Register  to view this content.