I have a project which is due tomorrow, end of day, so I'm panicing at this point. Any help would be greatly appreciated.
I need the macro to find duplicate entries in 2 separate columns (last name, first name) and delete the entry with those with a lower value in a third column.
For example,
Column A = Last Name
Column B = First Name
Column R = Final test result
So basically people who have taken a test more than once, only their highest mark will count, which is why I need to delete the lower test value.
If it matters, some people have also taken the test three times.
I need the macro to find duplicate entries in 2 separate columns (last name, first name) and delete the entry with those with a lower value in a third column.
For example,
Column A = Last Name
Column B = First Name
Column R = Final test result
So basically people who have taken a test more than once, only their highest mark will count, which is why I need to delete the lower test value.
If it matters, some people have also taken the test three times.