I'm looking to use the
=SORT function on some data, but I only want the first result with that name.
A contains a Name, column
B contains a level, and column
C contains a date. I'm currently using 1 sheet to list all the names, levels and dates, sorting that by date descending into a 2nd sheet, and then using a
VLOOKUP on a 3rd sheet to pull the data from the 2nd sheet.
The trouble with this is that I need to create an entry into the 1st sheet with the name, level, and date but then I also need to create an entry into the 3rd sheet (where I used auto complete for the
I'm thinking I can bypass the
VLOOKUP page completely if I can just sort page 1, but only have 1 entry per name. Is that possible?