is sit possible to auto populate a cell based on dates

wheddingsjr · #1 11-27-2017, 08:00 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto populate cell based on certain situations	YW3	Excel	10	05-26-2017 02:02 AM
Fixed Dates that Auto Populate	RustyK	Word	1	02-02-2016 03:17 PM
Excel to auto populate dates based on start and end	patidallas22	Excel Programming	9	04-21-2014 03:14 PM
auto cell populate 2	Stevejd58	Excel	3	08-20-2013 04:23 PM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM