I want to identify if a product was new in 2017 or 2018 as well as if the product was existing or has been removed.
To identify this I am using when the item was first sold. The equation I used was if(B5<Q4,"Exsisting"), if(B5="na",Delete),if(and(B5<=Q4, B5>=R4),"NPD 2017","",if(and(B5<=Q5...