Hey Excel Wizards,
I need some help.
I have some data that has names in multiple columns. These columns share the same list of names. It is a table tracking who was the lead on a job and who worked with him.
Now what I want to do is be able to pull all the data associated with a name no matter what column it is in. That way I could print a report for the one name of all the jobs he worked on.
It looks something like this:
Col.A, Col.B, Col.C, Col.D, Col.E...
Job, Lead, Lead$, Worker1, Worker1$, Worker2, Worker2$
I hope this is enough information that I can get some help. I have tried Pivot Tables, Vlookups, Matches, Filtering and sorting but nothing seemed correct. I feel I am on the right track just not getting it.
Thank you.
I need some help.
I have some data that has names in multiple columns. These columns share the same list of names. It is a table tracking who was the lead on a job and who worked with him.
Now what I want to do is be able to pull all the data associated with a name no matter what column it is in. That way I could print a report for the one name of all the jobs he worked on.
It looks something like this:
Col.A, Col.B, Col.C, Col.D, Col.E...
Job, Lead, Lead$, Worker1, Worker1$, Worker2, Worker2$
I hope this is enough information that I can get some help. I have tried Pivot Tables, Vlookups, Matches, Filtering and sorting but nothing seemed correct. I feel I am on the right track just not getting it.
Thank you.