|
|
#3
04-10-2021, 06:30 AM
|
||||
|
||||
Hi. It took me quite some time to get back. I applied the formulae to my actual workbook and it is perfect. The FILTER kicked aside the loooonnngg INDEX MATCH functions.
I cannot say enough thank you for all your generous help and sharing your expertise. I feel embarassed seeing in this forum the "Expert" tag below my name. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Auto Numbering of data except blanks starting from number n
|
Marcia | Excel | 13 | 09-09-2018 07:33 AM |
|
Return Multiple values from data except blanks with two criteria
|
Marcia | Excel | 7 | 09-07-2018 12:38 AM |
| Insert rows when column A data changes then shade and autosum blanks in columns E to I | kgoosen | Excel Programming | 0 | 08-30-2017 04:45 AM |
|
Copying data from sheet with deleted columns creates blanks
|
ZGreyArea | Excel | 1 | 11-20-2013 10:12 AM |
|
Data validation using indirect function
|
BullMouse | Excel | 2 | 11-30-2011 05:25 PM |
Windows 7 32bit 
Office 2013
Threaded Mode