Hi all

I am in a bit of a dilemma. I have 7k lines of data where I am going through to determine if certain factors makes the line a "Y" or a "N". Please see attached. Column "D" (Retract Y/N), will be populated by Y or N depending on if column "C" (TYPE) is an "E&M" and also occured just one day before the "PRE-OP" line. (see line 2) if the line is "PAID". Can this even be done?

Thanks in advance for any information that can be provided.

Attached Files

Book1.xlsx (15.8 KB, 17 views)