Thread: [Solved] Index match two date ranges
View Single Post
 
Old 11-03-2016, 03:10 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

I have tried again, column E and F in sheet Activity and have made some defined names, see Name Manager. The formula in column F is not mine but is due to a person named Amit Tandon.

Not sure if this gives you what you need, but you may want to take a look at it.
Attached Files
File Type: xlsx ExcelForum_DateRangeArrays_5.xlsx (136.8 KB, 20 views)
Reply With Quote