It is the month numbers, Jan- 1, Feb-2 etc.

The column that the month number is in is AO
--
Jim


"JLatham" wrote:

On the main list sheet, do you have dates or just month numbers in a column
to compare against the month number you are wanting to find? And what column
is that information in?

"Jim" wrote:

Hello, In Excel 2007 I am trying to create a new sheet that will list all
rows that have the same entry in it. I can not use the filter option on the
main sheet as each person will only be allowed to see their own data so is
there are function that might assist me?
I.e. If the person type Paul into a cell and the month number in to another
then the list that is created and displayed is all the rows that contain the
name Paul in column R for the given month.

Thanks for any asssitance offered
--
Jim