Excel Question regarding tables

[ace]

Guys,

This is the situation,

I have the following table;
Names Col B Col C Col D
Name1 F T2 W2
Name 2 W2 F2 M
Name 3 T2 TH2 F2
Name 4 F T2 W2
Name 5 F2 T W
Name 6 F2 T W
Name 7 M W TH
Name 8 M2 W2 TH2
Name 9 M2 W2 TH2
Name 10 M2 W2 TH2

Now columns B, C and D represent certain activities that happen on specific
days, M, T, w Th, etc
So if I wanna see all that happens on a Wednesday W, Then is there a way
that i can do something by which if i wanna see what all happens on a
wednesday, i can see the foll;
W Col D, Name 5 name 6
Col C Name 7.

Can this be done, preferably without a macro??

Thanks for your help in this matter,
Genuinely appreciate it,

Sincerely,
Ace

 

[ace]

Jacob,

Tried that, doesn't work.

Why dont you try Data>Filter..

 

[Jacob Skaria]

The below link should help

http://www.contextures.com/xlautofilter01.html

If this post helps click Yes