purplelily
New Member
- Joined
- Sep 25, 2005
- Messages
- 23
I apologise I do not know even how to begin to describe what I need to search for the formula I require (which I have always been doing, thanks to you all out here) and so here it is. I hope someone can help me with this formula.
I have two excel files or sheets:
The first one is where all my data is:
Person/Area Area1 Area2 Area3 Area4
PersonA green blue red yellow
PersonB red blue green yellow
PersonC yellow green red blue
PersonD yellow red blue green
I need a new excel sheet as follows:
Person/Color Red Blue Green Yellow
PersonA Area3 Area2 Area1 Area4
PersonB
PersonC
PersonD
What formula should I have in the second sheet in order to fill in the "Areas"?
Sorry, I don't know to present the above in table but only in text - every word (no space) is one cell.
Many thanks!!
pearlie
I have two excel files or sheets:
The first one is where all my data is:
Person/Area Area1 Area2 Area3 Area4
PersonA green blue red yellow
PersonB red blue green yellow
PersonC yellow green red blue
PersonD yellow red blue green
I need a new excel sheet as follows:
Person/Color Red Blue Green Yellow
PersonA Area3 Area2 Area1 Area4
PersonB
PersonC
PersonD
What formula should I have in the second sheet in order to fill in the "Areas"?
Sorry, I don't know to present the above in table but only in text - every word (no space) is one cell.
Many thanks!!
pearlie