I have an excel sheet where I want to make a list based on data in 3 columns. See the image for how the basic things looks currently.
I have names in column A and then in column B,C and D is a mixture of colours.
How can I get excel to list the names of those who choose for example Red despite Red possibly being in B,C or D? So it looks a little like:
- Harry Red
- Sara Red
- Sue Red
When it's finished it will have something like 2500 rows and "colour" choice of 27.
The output hopefully would look like this image with the ability to choose which colour it looks for