Hello Ladies and Gentlemen,
How can I identify duplicates in 16 rows and assign a number based on its position? Example Workbook attached. But here is a sample of the issue and desired result
Current
Points Team Score
16 A 100
15 B 100
14 C 90
Desired
Points Team Score
15.5 A 100
15.5 B 100
14 C 90
A macro is needed as there are 20 groups of 16 data sets. Only the Points row needs modified. Thank you!