Creating lists that are conditional on info in other cells

Closed
Posts
1
Registration date
Friday May 2, 2014
Status
Member
Last seen
May 2, 2014
-
Posts
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
-
Hi there,
I'm new here so I'll try and explain as best I can. This is probably really easy but I can't quite find the correct formula to do it, I assume it's some kind of sorting function.

I have two columns, they look like this :

A.....................B
Mosaic............Draft
Urban S..........Site
Jubilee............Site
Urban S..........Site
Jubilee............Draft
Mosaic............Site
Inter...............Draft
Mosaic............Site
Inter...............Draft
Jubilee............Draft

Column A is developer names, Column B is Plan Type.
In column C, I want a list of all the Developer Names that are of a Draft Plan Type.
In column D, I want a list of all the Developer Names that are of a Site Plan Type.

Eventually I will have hundreds of Developer Names of each Plan Type. I'd like it so that every time I put information in columns A and B, columns C and D will automatically populate with this new, sorted information.

Please help and please don't laugh at how easy this probably was to figure out :)

Thank you!

1 reply

Posts
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
491
Hi Vishk,

Why do you want to use 2 extra columns for that?

Just apply AutoFilter and whenever you want/need to see "Draft" developers, filter on Draft.

Otherwise to automate the process we would have to use macro's and that isn't easy.

Best regards,
Trowa