Attempting to sort unique/only count first record in each unique g
(...Could I have been any more cryptic?)
Hi All,
I'm currently trying to find a way to sort through several thousand customer
records (rows) in a sheet, filter in only the initial entries for each unique
customer (by date) and sum each unique initial record in each month/qtr/year
(the purpose is to determine in what month/year their initial purchase was).
I couldn't think of any remotely simple way to do this, any ideas on how to
do this minus VBA?
Thanks,
Jamie
|