Thread: Compare lists for additions and subtractions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
 
Posts: n/a
Default Compare lists for additions and subtractions
Join
=SUMPRODUCT(--(COUNTIF(LastMonth,ThisMonth)=0))
Quit
=SUMPRODUCT(--(COUNTIF(ThisMonth,LastMonth)=0))
Continue
=SUMPRODUCT(--(COUNTIF(ThisMonth,LastMonth)=1))

Using Advanced Filter and these formulas can give you
the list of names instead of just the count.

Reply With QuoteReply With Quote