Berry Metzger
asked on
CF match vertical DATENUM list to horizontal dates with a variable interval
I need a CF formula that compares each date in row 3 to the vertical holiday list on worksheet 'Holidays' and colors the cell(s) in row 3 when there is a match for the same WEEKNUM(nn,2) in range 'Holidays'$D$5:$D$40. The expected quantity of CF-colored dates should equal the 3-year range of the Holiday list...
Attempted CF formula =WEEKNUM(L$3,2)=MATCH(WEEK NUM(L$3,2) ,Holidays! $D$5:$D$40 ,1)... but this does not work correctly. Trying CF TEXT() formulas limits to only 3 correct 'hits' and only if using single-digit values in a series 1 to nn beneath the date series
sample workbook attached has layout and several attempts with CF formulas
CF-Vertical-to-Horizon-match.xlsx
Attempted CF formula =WEEKNUM(L$3,2)=MATCH(WEEK
sample workbook attached has layout and several attempts with CF formulas
CF-Vertical-to-Horizon-match.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Saurabh, that change works fine!
Yw..Always happy to help.. :-)
Saurabh..
Saurabh..
Open in new window
And then simply use paint brush to copy it on the rest of the data..
Enclosed your workbook where i have applied this...
Saurabh...
CF-Vertical-to-Horizon-match.xlsx