Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter question
How would I filter this?
I want to filter by week and I want Undeted States and the Name to show. United States United States United States Abraham Brandon Corey 4-Jan-08 11-Jan-08 18-Jan-08 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter question
Just add a helper column with a formula of say
=WEEKNUM(A2) and filter on this column -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LiveUser" wrote in message ... How would I filter this? I want to filter by week and I want Undeted States and the Name to show. United States United States United States Abraham Brandon Corey 4-Jan-08 11-Jan-08 18-Jan-08 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter question
I would use a helper column that calculates the Week nunber to your
requirements and then filter on the helper column. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "LiveUser" wrote in message ... How would I filter this? I want to filter by week and I want Undeted States and the Name to show. United States United States United States Abraham Brandon Corey 4-Jan-08 11-Jan-08 18-Jan-08 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter question
Bob. Thank you for responding. I am unfamiliar with this formula. I put it
in, but didn't really understand it. Do you mind elborating on what this formula does, how, and where it should be in relation to the other cells? Thank you. "Bob Phillips" wrote: Just add a helper column with a formula of say =WEEKNUM(A2) and filter on this column -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LiveUser" wrote in message ... How would I filter this? I want to filter by week and I want Undeted States and the Name to show. United States United States United States Abraham Brandon Corey 4-Jan-08 11-Jan-08 18-Jan-08 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter question
It just calculates the week number of the date cell. Add it to every row
that has a date. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LiveUser" wrote in message ... Bob. Thank you for responding. I am unfamiliar with this formula. I put it in, but didn't really understand it. Do you mind elborating on what this formula does, how, and where it should be in relation to the other cells? Thank you. "Bob Phillips" wrote: Just add a helper column with a formula of say =WEEKNUM(A2) and filter on this column -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LiveUser" wrote in message ... How would I filter this? I want to filter by week and I want Undeted States and the Name to show. United States United States United States Abraham Brandon Corey 4-Jan-08 11-Jan-08 18-Jan-08 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter question
With your data layout enter =WEEKNUM(A3) in B3.
Double-click on B3 to fill down. Select row 2 and DataFilterAutofilter. Filter on column B NOTE: the WEEKNUM function is from the Analysis ToolPak Add-in which must loaded through ToolsAdd-ins. Gord Dibben MS Excel MVP On Wed, 5 Mar 2008 09:06:03 -0800, LiveUser wrote: Bob. Thank you for responding. I am unfamiliar with this formula. I put it in, but didn't really understand it. Do you mind elborating on what this formula does, how, and where it should be in relation to the other cells? Thank you. "Bob Phillips" wrote: Just add a helper column with a formula of say =WEEKNUM(A2) and filter on this column -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "LiveUser" wrote in message ... How would I filter this? I want to filter by week and I want Undeted States and the Name to show. United States United States United States Abraham Brandon Corey 4-Jan-08 11-Jan-08 18-Jan-08 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter question? | Excel Discussion (Misc queries) | |||
Filter Question | Excel Discussion (Misc queries) | |||
Filter Question | Excel Discussion (Misc queries) | |||
Filter question | Excel Worksheet Functions | |||
Filter Question | Excel Discussion (Misc queries) |