Chi
New member
- Joined
- Jun 23, 2015
- Messages
- 29
- Reaction score
- 0
- Points
- 3
- Excel Version(s)
- excel 2013
I've been trying to find a formula that would produce 2 data lists from entering a text in a cell i.e a name. For example, in my extract sample shown below, there's a list of staff names in the 1st column, across the top are dates the staff members have worked and the 3 letter codes represents the jobs that they worked on on those dates. Is there a formula, perhaps an array formula, that would produce 2 data lists with the 1st list showing the dates the staff member worked and the 2nd list showing the jobs that they worked on on those dates, with only having to enter a staff name in a cell to produce these lists? Is this possible to create? and if so, how can this be done?
Any assistance would be most appreciated :wave:
Chi x
01-Jan | 02-Jan | 03-Jan | |
Tom | LIB | ONC | ROT |
Mark | SHO | WES | QUE |
Sam | SEV | ROT | CAR |
Emma | NEA | SHO | MEA |
Any assistance would be most appreciated :wave:
Chi x