SOLVED

Sorting out availability within a roster

Contributor

Hi all... As always love the community .

 

How do I extract names from a master list ? See Attachment. Please ask questions....  

 

 

2 Replies
best response confirmed by Cambosity100 (Contributor)
Solution

@Cambosity100 

In K4:

=FILTER(G4:G21,COUNTIF(H5#,G4:G21)=0)

@Cambosity100 

As variant

=FILTER( G4:G21, COUNTIF( H5#, G4:G21 ) -1 )