Are you saying that you cannot filter for a value of greater than or equal to
10 on a single column?
--
John C


"Naomi" wrote:

Sorry...I'm using Excel 2007. I don't think these tips work in that!
--
Naomi


"John C" wrote:

Assuming your dates of birth are in column A. Insert your helper column
before column B. In cell B2(or whatever row starts the dob's), type the
following formula:
=MONTH(A2)
Copy down as needed.
Next, highlight your entire selection of data, go to your menu bar
Data--Filter--Auto Filter.

Click on the pull down arrow in column B, select Custom. Then for Octber,
November and December, use the following:
is greater than or equal to 10
is less than or equal to 12
In this example, you really don't need the 12, as there are no months above
12, just showing for consistency and you can pattern for July-September, etc.

--
John C


"Naomi" wrote:

Okay, I've tried that however all I can get it to do is how me that I have 4
DOB's in the month of December for example. What I need is for it to show me
what consumers have a date of birth within the months of say October,
November & December.

Thanks! --
Naomi


"Reitanos" wrote:

I think what M Kan is trying to suggest is that if you added a new
column to your data you could use that to calculate the month (with
the MONTH() function) and then use the new column for sorting or
filtering. It's a common practice in Excel to create a "helper
column" (or row) that can be used in a way that the original data
cannot.

On Jul 29, 3:14 pm, Naomi wrote:
Ok. maybe I'm just being dense but I tried it and it's still not sorting by
month & why would I do it as coloumn when I already have my data in a coloumn
format? ARGGGG Thanks for being patient with me!
--
Naomi

"M Kan" wrote:
Sorry, meant a helper column. This would just be an extra column in Excel
where you calculate the month number.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips

"Naomi" wrote:

What is a helper row????? Thanks!
--
Naomi

"M Kan" wrote:

If all of your data is in Excel, you can add a helper row and use the formula
=Month(ref) to generate a month value (1-12) and then filter on that.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips

"Naomi" wrote:

I work in a medical office and need to do chart review by birth date. How
can I filter my table or a pivot table by date of birth within a month range.
Example: all dates of birth in October, November, December for any year!

PLEASE HELP ME!
--
Naomi