Hello everybody
For the date (column b), I want to see if the value in (column c) appears one day earlier after 03:00 (columns b and a)
Eg - for 10/19/20 the value apple does appear on row 7 on 10/18/20 after 03:00
For the instances when this occurs can a word be recorded in the original row in (column d) as text saying “match” ?
Worksheet attached, thanks for your time.
For the date (column b), I want to see if the value in (column c) appears one day earlier after 03:00 (columns b and a)
Eg - for 10/19/20 the value apple does appear on row 7 on 10/18/20 after 03:00
For the instances when this occurs can a word be recorded in the original row in (column d) as text saying “match” ?
Worksheet attached, thanks for your time.