Filter numbers
 

Hi
I work in office 2003, and don't have acces to newer formulars.
We have a worksheet with names in column A and dates in row 2. The
numbers(dates) changes downwards along with the names. The worksheet is
called may, so they are just formatted numbers; not dates..
Its a rather large list of names and the numbers varies from name to
name...The persons comes in different days in the month.

Allan (in A1)comes in from the 14th to the 20th, so in B14:B20 the numbers
14,15,16,17....20 are written.
Barbara (in B1)comes in from the 1st to the 12th and then again from the
17th to the 22nd.
In cell A32 we would like "14" to appear, and "20" in A33.
The same goes for row B; in cell B32 we would like "1" to appear and "12" in
B33. In B34 we would like to see "17" and "22" in B34.
Is this possible?
Some comes in twice.
If it's too complicated to get two sets of numbers, we would be super-duper
happy to just have the first and last dates in A32 and A33.
Thanks
Therese

Filter numbers
 

On Tue, 4 Mar 2008 05:21:01 -0800, Therese
wrote:

Hi
I work in office 2003, and don't have acces to newer formulars.
We have a worksheet with names in column A and dates in row 2. The
numbers(dates) changes downwards along with the names. The worksheet is
called may, so they are just formatted numbers; not dates..
It’s a rather large list of names and the numbers varies from name to
name...The persons comes in different days in the month.

Allan (in A1)comes in from the 14th to the 20th, so in B14:B20 the numbers
14,15,16,17....20 are written.
Barbara (in B1)comes in from the 1st to the 12th and then again from the
17th to the 22nd.
In cell A32 we would like "14" to appear, and "20" in A33.
The same goes for row B; in cell B32 we would like "1" to appear and "12" in
B33. In B34 we would like to see "17" and "22" in B34.
Is this possible?
Some comes in twice.
If it's too complicated to get two sets of numbers, we would be super-duper
happy to just have the first and last dates in A32 and A33.
Thanks
Therese


This is not any more clear than your previous post. So I will repeat my
previous response:

=====================
It's all probably possible, but you will need to describe your setup better.

For example, you write

Names in Column A; Dates in Row2

But Barbara is in B1 (which is column B, not column A)
-------------------------

From what you write, it seems that if Allan were in on the 1st, there would be
a one in B1, overwriting Barbara.

--------------------------------
--ron

Filter numbers
 

Here's the way to get the 1st and last day.

First Day = MIN(A1:A10) ...change the range as needed
Last Day = MAX(A1:A10)

First and last day of each group would be more complicated so that it was
consistent from row to row.
--
HTH,
Barb Reinhardt



"Therese" wrote:

Hi
I work in office 2003, and don't have acces to newer formulars.
We have a worksheet with names in column A and dates in row 2. The
numbers(dates) changes downwards along with the names. The worksheet is
called may, so they are just formatted numbers; not dates..
Its a rather large list of names and the numbers varies from name to
name...The persons comes in different days in the month.

Allan (in A1)comes in from the 14th to the 20th, so in B14:B20 the numbers
14,15,16,17....20 are written.
Barbara (in B1)comes in from the 1st to the 12th and then again from the
17th to the 22nd.
In cell A32 we would like "14" to appear, and "20" in A33.
The same goes for row B; in cell B32 we would like "1" to appear and "12" in
B33. In B34 we would like to see "17" and "22" in B34.
Is this possible?
Some comes in twice.
If it's too complicated to get two sets of numbers, we would be super-duper
happy to just have the first and last dates in A32 and A33.
Thanks
Therese

Filter numbers
 

Thanks a lot :-) I will use it for some of the sheet but need the rest as well.

Therese

"Barb Reinhardt" wrote:

Here's the way to get the 1st and last day.

First Day = MIN(A1:A10) ...change the range as needed
Last Day = MAX(A1:A10)

First and last day of each group would be more complicated so that it was
consistent from row to row.
--
HTH,
Barb Reinhardt



"Therese" wrote:

Hi
I work in office 2003, and don't have acces to newer formulars.
We have a worksheet with names in column A and dates in row 2. The
numbers(dates) changes downwards along with the names. The worksheet is
called may, so they are just formatted numbers; not dates..
Its a rather large list of names and the numbers varies from name to
name...The persons comes in different days in the month.

Allan (in A1)comes in from the 14th to the 20th, so in B14:B20 the numbers
14,15,16,17....20 are written.
Barbara (in B1)comes in from the 1st to the 12th and then again from the
17th to the 22nd.
In cell A32 we would like "14" to appear, and "20" in A33.
The same goes for row B; in cell B32 we would like "1" to appear and "12" in
B33. In B34 we would like to see "17" and "22" in B34.
Is this possible?
Some comes in twice.
If it's too complicated to get two sets of numbers, we would be super-duper
happy to just have the first and last dates in A32 and A33.
Thanks
Therese