Hi,

Assuming your dates start in A2, put this in D2 and drag down

=COUNTIF($A$2:A2,A2)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Cam" wrote:

Hello,

I have a sheet with date (some have the same date), order# (6 numeric
digits, etc.. I want to add another column to look if there are more than one
record with the same date, sequentially add a placeholder 1, 2, 3, etc. to
this column. What function do I use? Thanks

Sample:
Date Order# Part#
5/2/10 123456 AA
5/2/10 356450 AA
5/5/10 356480 AB
5/9/10 356000 AA
5/9/10 256450 BC
5/9/10 306450 AB

Result:
Date Order# Part# Placeholder
5/2/10 123456 AA 1
5/2/10 356450 AA 2
5/5/10 356480 AB 1
5/9/10 356000 AA 1
5/9/10 256450 BC 2
5/9/10 306450 AB 3