Removing dupliate rows where reference columns has blank cells

[dinsyp]

Hi People,

I have a spreadsheet where there a more than 6000 people who have completed an online quiz. Some have done it more than once; others haven't started. So there are some people appearing 2-3 times with two different scores, and some appearing with no score at all.

How do I remove all rows apart from that with the highest score?

Spreadsheet layout below - the column with the scores is column G.

Anyone able to guide me - VBA is likely to be the best choice I suspect.

Regards

Andrew

 

[Alan_P]

Hi dinsyp,

You could try; sort column G highest to lowest, then select all your columns and click "Remove duplicates" on the data tab, un-tick everything except the name column and hit ok. This will keep only the first occurance of each name and since you've sorted the score column highest to lowest the first occurance will be the highest score...

Hope this helps,
Cheers,
Alan.

 

[dinsyp]

Thanks Alan,

Worked although I had to also select both the family name and the given name.

Much appreciated.

Andrew

 

[Alan_P]

No prob Andrew, Glad I could help