I am working on a report that shows different names in column A. I want to compare the values from COL B for each country in column A. In COL C, I would like to return the maximum value from COL B for that country. This is an example of what I'd like:
COL A COL B COL C (OUTPUT RESULT REQUIRED) Row 1 USA $3 - Row 2 USA $7 $7 Row 3 Italy $1 $1 Row 4 France $2 - Row 5 France $9 $9 Row 6 France $4 -
I am using Excel 2016.
How can I do this with a function?