Thread: Count duplicates as unique record, sum amounts?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default Count duplicates as unique record, sum amounts?
The code you posted produced a list of invoice numbers with 1
instance. My modification to it adds invoice numbers with only 1
instance. You could use that list and SUMIF's to get $ amts. If you
want to sum and combine data across multiple sheets, that is a
different matter.

Merjet


Reply With QuoteReply With Quote