I have a list of clients in A6:A101.
If criteria is met in cells D6:D101, I just entered an X.
I am trying to have the names of all clients with X's in cells D6:D101 output and list in another column.
The formula is in AB6.
As you can see, I have it working for cell AB6, but it is...