How to sort by top five most recent dates, and carry corresponding information

[emmarosz]

Hello -

After struggling with this issue I decided to register here and see if anyone can help me. I would really, really appreciate it! My base sheet is a large table of information that is constantly being added to. In sheet #2 I have sorted the information by ID #, which correlates to date, in descending order (ie. most recent at the top of the sheet). I've done this because I needed to sort other categories by most recent, something I already figured out. THE ISSUE: On sheet #3, I want to pull the top five most recent entries (the same dates with different info are okay) for both the categories "Chasis" and "NVH" from sheet #2, along with the information associated with them in the other columns of the table on sheet #2. I've attached an abbreviated version of what my workbook looks like. Sheet #1 doesn't really matter so I've just included sheet #2 and #3. The summary sheet shows what I want to happen based on the table in sheet #2.

[alansidman]

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.