I need help with a formula that will find an specific cell when it meet
specific criteria.

A B C
1 Monday 11/10/2008 1
2 Tuesday 11/11/2008 0
3 Wedy 11/12/2008 1
4 Thursday 11/13/2008 1
5 Friday 11/14/2008 3
6 Saturday 11/15/2008 2
7
8 Monday 11/17/2008 2
9 Tuesday 11/18/2008 2
10 Wedy 11/19/2008 1
11 Thursday 11/20/2008 2
12 Friday 11/21/2008 3
13 Saturday 11/22/2008 1
..
..
..

I want a formula that can find the number on column C after each Monday on a
different sheet. Another for Tuesday, Wednesday and so on.

Is that possible?

Thank you in advance,

Maurolava

Why not just leave on one sheet and use datafilterautofilter to work with
it.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Maurolava" wrote in message
...
I need help with a formula that will find an specific cell when it meet
specific criteria.

A B C
1 Monday 11/10/2008 1
2 Tuesday 11/11/2008 0
3 Wedy 11/12/2008 1
4 Thursday 11/13/2008 1
5 Friday 11/14/2008 3
6 Saturday 11/15/2008 2
7
8 Monday 11/17/2008 2
9 Tuesday 11/18/2008 2
10 Wedy 11/19/2008 1
11 Thursday 11/20/2008 2
12 Friday 11/21/2008 3
13 Saturday 11/22/2008 1
.
.
.

I want a formula that can find the number on column C after each Monday on
a
different sheet. Another for Tuesday, Wednesday and so on.

Is that possible?

Thank you in advance,

Maurolava

Two reasons. One the sheet is really big, and two I need to create a scatter
chart that will contain a series for Monday, Tuesday, Wednesday, etc. which
need to be in a continous column.

"Don Guillett" wrote:

Why not just leave on one sheet and use datafilterautofilter to work with
it.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Maurolava" wrote in message
...
I need help with a formula that will find an specific cell when it meet
specific criteria.

A B C
1 Monday 11/10/2008 1
2 Tuesday 11/11/2008 0
3 Wedy 11/12/2008 1
4 Thursday 11/13/2008 1
5 Friday 11/14/2008 3
6 Saturday 11/15/2008 2
7
8 Monday 11/17/2008 2
9 Tuesday 11/18/2008 2
10 Wedy 11/19/2008 1
11 Thursday 11/20/2008 2
12 Friday 11/21/2008 3
13 Saturday 11/22/2008 1
.
.
.

I want a formula that can find the number on column C after each Monday on
a
different sheet. Another for Tuesday, Wednesday and so on.

Is that possible?

Thank you in advance,

Maurolava

If it's that big, I would still use datafilterautofilterfilter on the
daycopy/paste. Incorporate in a loop for each day.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Maurolava" wrote in message
...
Two reasons. One the sheet is really big, and two I need to create a
scatter
chart that will contain a series for Monday, Tuesday, Wednesday, etc.
which
need to be in a continous column.

"Don Guillett" wrote:

Why not just leave on one sheet and use datafilterautofilter to work
with
it.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Maurolava" wrote in message
...
I need help with a formula that will find an specific cell when it meet
specific criteria.

A B C
1 Monday 11/10/2008 1
2 Tuesday 11/11/2008 0
3 Wedy 11/12/2008 1
4 Thursday 11/13/2008 1
5 Friday 11/14/2008 3
6 Saturday 11/15/2008 2
7
8 Monday 11/17/2008 2
9 Tuesday 11/18/2008 2
10 Wedy 11/19/2008 1
11 Thursday 11/20/2008 2
12 Friday 11/21/2008 3
13 Saturday 11/22/2008 1
.
.
.

I want a formula that can find the number on column C after each Monday
on
a
different sheet. Another for Tuesday, Wednesday and so on.

Is that possible?

Thank you in advance,

Maurolava