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 :)
Creating lists that are conditional on info in other cells