Formula, Macro, or Pivot to compile stats?

[pskwaak]

Not sure if I would use a formula, macro, or pivot table, or even another method of data collecting, but here's what I have:

I keep baseball game statistics in a workbook and would like to calculate the number of consecutive games a player has a hit, dating from the most recent game date. (For those who follow baseball, I'm looking for the batter's current hitting streak.)

I transfer each game's statistics ("box score") onto a cumulative list of games played by all teams (attached worksheet). I would like to add a column that depicts the player's current "hitting streak."

The relative columns are A ("Player), C ("Game Dt"), F ("H") and T ("PA"). Would want to read up the data until the specified player has 0 in column F and column T is greater than 0.

I already have a pivot table for the players' statistics, based on the data in this worksheet...just need to add the hitting streak data.

Clear as mud? Suggestions?

I could use Access, but I'm not as familiar with it and I love working with Excel.

Thanks in advance!