I want to lookup the max value in Col A, and have the name/s, which are in Col B, returned in another part of the sheet.
I have attached a sample workbook.
How can I do this? Do I have the option to either have names in separate cells or concatenated?
Many TIAs!