|
|
#9
12-11-2023, 07:15 AM
|
||||
|
||||
A different approach.
See table at cell H26. I changed a date (cell E3) in the source data to cause overlaps (I know, it may never happen) so you can see what happens in the results (T28:V28). If the source data changes, the table (a pivot table) will need refreshing (right-click it and choose Refresh). [The whole thing is a Power Query on your source data, which loads to the Pivot Table, with the data added to the Data Model so that a measure (txt) can be added and used in the Values area of the Pivot table.] Last edited by p45cal; 12-11-2023 at 07:02 PM. Reason: corrected name of attached file 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Multiple match values for INDEX(MATCH) formula | jn82740 | Excel | 1 | 06-24-2023 11:48 PM |
| Excel Index and Match function with multiple criteria not searching the next record | mushtaqkadar | Excel | 3 | 06-17-2017 12:20 AM |
| UDF multiple IFs INDEX-MATCH | grexcelman | Excel Programming | 0 | 02-22-2015 04:20 PM |
| Help with multiple match and index formula | ryanwood | Excel | 1 | 09-12-2012 07:53 AM |
 Vlookup or Index/Match - Multiple Criteria
|
ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |
Windows 10 
Office 2021
Threaded Mode