Flag logic for same date range
I have to get below table of figure, inb that i have date, column A & B. I need to get Score column.
Score column logic is, Column A value should be checked in Column B with respect to date. For example, value A in column A is available in column B but not same row (that is not a problem). same for E which is available in Column B on 17.05.2015 date range.
How to achieve this?