Quote:
Originally Posted by Agnieszka
Hi, I tried doing everything from the start but some of the things you did are happening in the background that I can't work out.
|
The only thing not entered directly into formula is defining the Name nDates, which represents the range Report!$C$1:$L$1. In my Excel, I can define name selecting from Main menu Formulas>[Name Manager]. Btw. There you'll find also all Defined Tables, and all DataRanges of ODBC queries in case you have defined them for this file.
Btw. I added here an example, how make it even more 'background'
12-13-2023, 01:47 AM
Similar Threads
Vlookup or Index/Match - Multiple Criteria
Windows 8 
Office 2016
Threaded Mode