Looking for a formula

[Maurolava]

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

 

[Don Guillett]

Why not just leave on one sheet and use data>filter>autofilter to work with
it.

 

[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]

If it's that big, I would still use data>filter>autofilter>filter on the
day>copy/paste. Incorporate in a loop for each day.