Quote Originally Posted by nicci113 View Post
@AlanY I think you reply gives me the answer but honestly I don't understand the logic!
It's just match the date on E1 to A1 to D1 then add the column the matched all the way down,
Both the range A1 to D1 and A2 to A50 can be amend to suit