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