Thread: [Solved] List max values in a range
View Single Post
 
Old 04-19-2017, 06:04 PM
Bella06 Bella06 is offline Windows 7 32bit Office 2013
Novice
 
Join Date: Apr 2017
Posts: 6
Bella06 is on a distinguished road
Default 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
Reply With Quote