Filter question

[LiveUser]

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

 

[Bob Phillips]

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)

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[LiveUser]

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]

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)

 

[Gord Dibben]

With your data layout enter =WEEKNUM(A3) in B3.

Double-click on B3 to fill down.

Select row 2 and Data>Filter>Autofilter.

Filter on column B

NOTE: the WEEKNUM function is from the Analysis ToolPak Add-in which must
loaded through Tools>Add-ins.


Gord Dibben MS Excel MVP