Hi there. I'm trying to do the following. I have 4 teams with 9 players on
each team. I want to keep track of when someone scores. I also want to keep
track of the last time they scored.

So...

Col A lists the day (simply 1-31, no month needed).
Col B I list the player that scored that day. Only 1 player scores per day.
Col F is Team 1. When a player from team 1 scores, It imports to the first
empty row in Col F.

This is were I'm having problems. How do I get the cells in Col F to
examine each day and see if someone from Team 1 has scored. And if they have
scored, to enter the day they scored on the next available row.

I hope this makes sense!

Thanks,
Matt