display list of data based on date

i have a recruitment pipeline of people at different stages all based on date

so i have an ID number / name / job role for each person

then i have dates for stage 1 / stage 2

on a new sheet i want to display say a list of people at stage 1 and then a new list of people at stage 2

tried index and vlookup but lost me 100%

Hi

Try to provide a small data sample (~10 rows) along with expected result.

Not image please.

… And the way to do that is:

... click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon (attachments button), as it doesn't work on this forum.

Hope this helps.

Pete

.
Here is one meethod :

Please Login or Register  to view this content.

file example attached

thanks