highest score for multiple ids 1

[flashbbeb]

Hi all,

I have a list of duplicate user ID numbers for people who completed a course multiple times.

Their record includes a score for each attempt at the course.

I need to extract the highest scores for each user ID.

Not being someone who can program from scratch, could anyone assist with a formula or macro? I'd be happy with a formula I could just drop into a column to the right of the existing records.

Thanks,
EB

 

[combo]

What application and data format? In case of table in excel use pivot table. ID as row field, score as data field, max as domain aggregation. Format table report, remove totals/subtotals, change titles to get the view you like.
No coding required.

combo

 

[flashbbeb]

Excellent - I haven't used Pivot Tables in a few years, so it took a few minutes to get back into them, but that worked!