Thread: consolidating lines based on duplicity
View Single Post
 
Old 07-07-2017, 04:54 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
You can add formula in H2:

=IF(D2&"_"&F2<>D3&"_"&F3,SUMIFS($G$2:$G$25,$D$2:$D $25,D2,$F$2:$F$25,F2),"")

copied down.

Then you can filter the table by non-blanks in column H and cut and paste to your other location.
Reply With Quote