Mar 01 2019 11:18 AM
Hi All,
I'm trying to figure out how to pull unique text from a sheet into one column on another.
We have a spreadsheet with scheduled projects for the month with other project data. Some of this information is duplicated representing multiple days working on one project.
I'm trying to pull unique project names into a column on another spreadsheet to use for reference when being billed. I've attached photos to show how I would like the column to look but automated through a formula.
Mar 01 2019 11:37 AM
Mar 02 2019 04:12 AM
As variant that could be done by Power Query. Not easy, but perhaps the easiest possible way with such data structure.
In general it's better to build data in opposite way - have list of your projects and insert them in schedule using data validation drop-down list.