In column A I have PC Names, In column B I have the location name and column C the speed data.
The data shows PC abc several times with different or sometimes the same speed data. I only need the highest speed and to remove any duplicate PC Names as I only want one instance of the PC Name. I have the data sorted by speed data (column C) but have several instances of the same PC name showing up and it's not all together. I've tried sorting by column C highest to lowest and adding sort column A by A-Z but I find the PC names in Column A all over the place and not sorted together.
Basically I need the speed data highest to lowest and only 1 instance of the PC Name. This will tell me who is running the highest speed without mistakenly contacting them twice or three times.
Please see attached file for sample.