Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Question regarding tables
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Question regarding tables
Why dont you try DataFilter..
-- If this post helps click Yes --------------- Jacob Skaria "ace" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Question regarding tables
Jacob,
Tried that, doesn't work. "Jacob Skaria" wrote: Why dont you try DataFilter.. -- If this post helps click Yes --------------- Jacob Skaria "ace" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Question regarding tables
The below link should help
http://www.contextures.com/xlautofilter01.html If this post helps click Yes --------------- Jacob Skaria "ace" wrote: Jacob, Tried that, doesn't work. "Jacob Skaria" wrote: Why dont you try DataFilter.. -- If this post helps click Yes --------------- Jacob Skaria "ace" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables Question with Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 97 Question (Pivot tables) | Excel Discussion (Misc queries) | |||
My question is about Excel how to create tables by multiplication | Excel Discussion (Misc queries) | |||
Pivot Tables - "simple" question | Excel Discussion (Misc queries) | |||
Question about Pivot Tables..why is that | Excel Discussion (Misc queries) |