List max values in a range
Hi I need help trying to list the max values in a new column. If my data is as follows:
Column A; Column B; Column C;
1. Adelaide; Sara Poon; 1
2. King; Jason Ex; 2
3. Wellington; John Smith 1
4. Bill; John Smith; 1
5. King; Jason Ex; 3
6. Adelaide; Joe Shoe; 2
7. Adelaide; Joe Shoe; 1
8. King; Jason Ex; 1
I need to results in column D to read the highest value from column C if column A and B match and return a value of 0 for all other columns. For example rows 2, 5, and 8 have the same name in column A and B but I want to capture the highest value from column C which is row 5. The output I am wanting is as follows:
Column A; Column B; Column C; Column D
2. King; Jason Ex; 2; 0
5. King; Jason Ex; 3; 3
8. King; Jason Ex; 1;0
|