#1
|
|||
|
|||
is sit possible to auto populate a cell based on dates
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. |
#2
|
||||
|
||||
Could you please add some more expected results ( with eventually a short explanation) to your sheet? Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Hi Peco and thanks for replying. Unfortunately I am not sure what else I can add. Just a quick and easy way to get the results I previously explained. I just need to determen if the E&M lines are dated prior to the Pre-Op line per MEMNO.
|
#4
|
|||
|
|||
oops sorry...dated one day before the pre-op line.
|
#5
|
||||
|
||||
Sorry I don't get the logic. Perhaps someone else will. Cheers
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
||||
|
||||
Does this work?
=IF(AND(B2="PAID",C2="E&M",SUMIFS($E$2:$E$21,$A$2: $A$21,A2,$C$2:$C$21,"PRE-OP")=E2+1),"Y","N") |
#7
|
|||
|
|||
Hi NBVC
That works perfectly. Thank you very much. Wheddingsjr |
Thread Tools | |
Display Modes | |
|
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 |