Hello. I hope somebody can help me on this one. I have been trying this for a day or so and looked up on google and this site to no luck.
I want to be able to run a VLOOKUP (or alternative) after creating a subset through MAXIF. Here is an example with some data. I can use the MAXIF function to tell me that 300 is the top score by an English competitor, and that 155 is the top score by a Spanish competitor but I want a formula that tells me that Alan is the top English competitor and that Charles is the top Spaniard, and that Greg is the top Frenchman.
A - B - C (A1:C8 Data Table)
Alan - 300 - England
Brian - 180 - England
Charles - 155 - Spain
Don - 200 - France
Edgar - 12 - Guinea
Francis - 13 - Spain
Greg - 210 - France
Harry - 222 - Haiti
Many thanks
<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>
I want to be able to run a VLOOKUP (or alternative) after creating a subset through MAXIF. Here is an example with some data. I can use the MAXIF function to tell me that 300 is the top score by an English competitor, and that 155 is the top score by a Spanish competitor but I want a formula that tells me that Alan is the top English competitor and that Charles is the top Spaniard, and that Greg is the top Frenchman.
A - B - C (A1:C8 Data Table)
Alan - 300 - England
Brian - 180 - England
Charles - 155 - Spain
Don - 200 - France
Edgar - 12 - Guinea
Francis - 13 - Spain
Greg - 210 - France
Harry - 222 - Haiti
Many thanks
BC | ||
<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>