View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MJW[_2_] MJW[_2_] is offline
external usenet poster
 
Posts: 39
Default 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