Say i have a sheet with a list of first names in column A, last names in column B and their favourite colour in column C.
Is there a way to produce a list of names (as a column) for each favourite colour?
Would really appreciate any help.
Antony
Say i have a sheet with a list of first names in column A, last names in column B and their favourite colour in column C.
Is there a way to produce a list of names (as a column) for each favourite colour?
Would really appreciate any help.
Antony
Hi Antony,
Welcome to the forum.
It would be good (without coding as well) if you use an extra column to assign a specific code for colours.. i.e., 1 for Red, 2 for Green etc.. and then you can produce the list of names basis these codes.. it would be far simple and quick.. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks