I have two sheets.
Sheet 1 has listing of individual transactions with columns A date, B name, C email and D value columns
Sheet 2 is a listing (in column A) of unique values extracted column C in Sheet 1) + a range of columns (B......AW) each with a date range in title (Example column B has date 08/03/2021 in cell B1 and "14/03/2021" in cell B2).
What I need (and after a couple of hours trying clearly beyond my skills, although I may kick myself I was circling around the solution)
In Sheet 2, in each cell in columns (B....AW), return a "1" or a "0") if
- (1) value of A2 in Sheet 2 is present in column C in Sheet 1, and
- (2) where it is present the date in column A on same row is => that B1 and =< B2)
In words, I would like to know, the weeks in which each email in Column A in Sheet 2 made a purchase or less.