I've searched through the "maximum based on criteria/conditions" threads and they have helped in my understanding, but I am missing a key part to help solve my excel issue.
What I have is a list of names in one column, a number in the next column, and then a blank column next to that (three in total). An example below:
Smith, Joe, XK ---------------- 12--------------BLANK
Parker, Ed, XZ -----------------15--------------BLANK
Yates, Doug, TY---------------- 2-------------BLANK
Chandler, David, XK -------------1------------BLANK
Hughes, Luke, TY ---------------3------------BLANK
What I would like to have is a function that would have the largest number corresponding to a name with "XK" be marked with an "x" in the blank column. To help clarify, I want to mark in the blank column the highest valued people corresponding to their specific abbreviation next to their name.
Something to the effect of:
Smith, Joe, XK ---------------- 12--------------X
Parker, Ed, XZ -----------------15--------------BLANK
Yates, Doug, TY---------------- 2-------------BLANK
Chandler, David, XK -------------1------------BLANK
Hughes, Luke, TY ---------------3------------X
Any help would be greatly appreciated. Please let me know if I need to clarify my issue.