Unique Entries

[Tashia]

Hello,
How can I retrieve unique entries when:
Column A = list of sites
Columns B through E lists programs offered with values Y or N.
Column B = tai chi
Column C = cooking
Column D = dance
Column E = yoga

Here are examples:
I would like to see the sites that...
1. ONLY have yoga.
2. have cooking AND dance (nothing else)

Thank you!!

[seckert]

You can use Data.Filter.AutoFilter to allow you to select only those records in the list you want to see, be it using one filter (Yoga="Y"), or a combo (cooking=Y, dance= Y, Yoga=N) etc...

SAE

[Tashia]

I get it.. thank you.