Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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
1  
Could you share the spreadsheet with us? –  Vidar S. Ramdal Jan 22 at 8:28

1 Answer 1

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

Your Answer

 
discard

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.