Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking to use the =SORT function on some data, but I only want the first result with that name.

Column 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 VLOOKUP).

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?

share|improve this question
Could you share the spreadsheet with us? – Vidar S. Ramdal Jan 22 '14 at 8:28

I think yes, if you are prepared either to move your date column to the extreme left or maybe have a copy of it there, that could be hidden if necessary.

share|improve this answer
This answer is extremely vague. More information is required (i.e. how, why, etc.). – Michelfrancis Bustillos Mar 15 at 13:36

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.