help with pulling data from a doc into a summary.

[staceburgers]

Hi I have a large spreadsheet for my projects and i need to get a summary of which stages each project is at. Staff fill in the date of each stage when it has been completed. 

 This is only a snapshot of the size and i have removed the actual info. 

What i need is a list of the Project Codes and which stage they are at. 

Anyone?

[#2]

@staceburgers 

You have not specified the Excel version that you use.

Collecting a list of distinct Project Codes is easy enough with Excel 365.  Once that is done the table can be filtered to show a specific project. 

Why

are there 4 rows for each project;

is the information held in the green rows similar to the white rows; is the project stage determined by the rightmost date;

why does stage 2 have an additional column?

[#3]

Hi i am using office 2019

There are 4 rows for each project as it comes in different sizes. These need to be reported per size. 

Yes the green rows are where they have been identified that we arent making that size and the project is determined by the rightmost date. 

Unfortunately i didnt make the spreadsheet the additional column on stage 2 only shows the Version number. It is insignificant really. 

@Peter Bartholomew