Sequential Numbering of Unique Entries

Hi All,

A little background, I have an event management doc that lists all of the information about events during the year (name, time, place, lead counts, cost, etc). I would like to use this document to create a dynamic calendar that populates some information about each event in the appropriate date box (I might need some help on that later). To do this, my current thought is to assign each event a unique id (based primarily on the date) so that I can match it up to a date in the calendar. This is a living document that is always being updated and added to, so id might change as more info is added.

Here is my hold up: I would like to assign a sequential count to each event on a given day, in a given county, by time. So that Event "AA" on 01/01, in LA would have an id of 1, and "AB" on 01/01 in LA would have an id of 2; "AD" on 01/01 in OC would have an id of 1.

In essence, the sequence restarts everyday, for each county and is ranked by time (then by key if time is the same).

(If there is an easier way to do this (or the calendar thing) please let me know...)

Thanks for the help!!

Art