|
|
#2
06-18-2020, 01:16 AM
|
|||
|
|||
I think index and match is what you are looking for
=INDEX($D$17:$BOB$23,MATCH($C43,$C$17:$C$23,0),MAT CH(D$42,$D$16:$BOB$16,0)) Do you have something to work out the dates with a delivery? if so the above seems to work I would also reccomend turning the data around so that the feed is along the top and the dates at the side, it will be much easier to manage and read. 
|
| Tags |
| consolidate, list without blanks, table |
| Thread Tools | |
| Display Modes | |
|
|
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 2019
Threaded Mode