'How to find highest value in adjacent column and paste the name and the value to another range
I have a table like
A list of the name in the first column and a list of there score each time. I want to find each players highest score and paste it to another place.
End result should be Table2
This is a simpliefied version of what I have but is essentially the same thing, I am using this within a vba project but happy to use formulas and get the macro to fill them in.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|