Hi all

Having searched through many topics and tried various formula cant see what would be best for this, hoping it something simple you guys could me with please?

All i know of excel if self-taught so forgive me if this is a silly Q

Client Ordered Installed
A Yes Yes
B Yes No
B Yes Yes
C Yes No
D Yes Yes
E Yes No
F Yes Yes

We have 5 spreadsheets for 5 sales guys and we want to keep tracked of those clients who have had their system installed, display a list of them and another list of those who haven't.

I know how to link the sheets but its getting a list of the clients who have "yes" at installed and those with "no"

Any help muhc appreciated.

Thanks

Nick