The sheet I am working with has a column of ~150 names (A2:A151). A1
has the title "Names".
The 27 cells to the right of A1 (A1:A28) all have their own name based
on specific criteria.
If the person in column A meets any of the criterea an X is placed in
that cell. So Name A2 might have A3,A4,A7,A20 all filled in with an X
with the rest of the cells blank.

What I need to do is break the names into lists based on whether they
meet one or more of the criteria. So if the name of column B1 is
"Likes Dogs" I want to have a list created elsewhere of every name in
the spreadsheet that has an X in that column. I need to make a list
like that for every criteria on the sheet.

What I also need to do is to create lists based on multiple criteria.
So if B1 is "Likes Dogs", C1 is "Likes Cats" and G1 is "Takes Long
Naps" I might need a list of all people on the sheet that have an X
under all three.

I have done a lot of If statements and other formulas as well as some
minor VBA - but this process has eluded me so far. Any help or
direction is greatly appreciated.