|
|
|
|
#1
07-07-2017, 04:54 AM
|
||||
|
||||
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. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Consolidating Rows with same Resource Name | OTPM | Excel Programming | 2 | 05-30-2017 08:30 AM |
 Consolidating various word docs in one
|
Max Downham | Word | 6 | 11-23-2015 05:07 PM |
| Consolidating Sentences into One Paragraph | ctsolar | Word | 4 | 12-16-2013 04:50 PM |
|
Consolidating data using Macro
|
mrjamez | Excel Programming | 2 | 05-22-2012 06:50 AM |
| Help with consolidating multiple records into one | wbiggs2 | Excel | 0 | 11-30-2006 01:02 PM |
Windows 10 
Office 2013
Hybrid Mode