I think that you should better explain your problem, but as I could find out
what are you looking for, maybe it could help.

It looks like that you have a two worksheets as a two tables which are in
1-many relation (if this tables are in some relational database management
system).

As I could figure it up, you have on Worksheet1 column ID with unique
values, and Worksheet3 with some data where column ID could have been entered
a few times and also for each row you don't enter the date in the column E if
is the same as above? Am I right?

If Worksheet3 is sorted by column ID (Column A) you can find the number of
corresponding rows on Worksheet3 with this formula typed in I2 and copied
down:

=MATCH(A2,Worksheet3!A:A)-MATCH(A2,Worksheet3!A:A,0)+1

Maybe me/someone can help you more if you represent your data.




"jeannie v" wrote:

Hi:

I'm not sure if Excel will allow me to do what I want to do, but I wanted to
touch base with a few Excel gurus to make sure before I begin reviewing them
manually.

In column I of the €˜Worksheet 1', I want to return the count of how many
skips from the €˜Worksheet 3' occur after the date included in column E on
'Worksheet 3', but I only want this information if the ID from column A on
'Worksheet 3' matches on both Worksheets.

Any suggestions or alternative options that might accomplish this would be
greatly appreciated! Please let me know if you have any questions

Thank you for your help,
--
jeannie v