|
|
|
|
#1
06-18-2020, 11:03 PM
|
|||
|
|||
Hello mate try
Helper row in 15 - =COUNTIF(D17:23,">"&0) I have added this in row 41 and it seems to be okay =SMALL(IF($D$15:$BOB$15>0,$D$16:$BOB$16,""),COLUMN S($D$41:41)) Noticed you have merged cells on this work sheet and it is interferring with some formulas - be very careful of Merged cells as nothing good will ever come of them and they will cause you issues at some point. Also row 22 was hidden 
|
|
#2
06-20-2020, 01:42 AM
|
|||
|
|||
|
Purfleet, you are a legend mate thank you so much!!
|
|
| Tags |
| consolidate, list without blanks, table |
|
|
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
Hybrid Mode