Hi,
I feel like this should be really easy with an if statement and a concatenate but the max on the date is throwing me off.
I'm looking to add a formula to column F that determines the line is "LIVE" or "INACTIVE"
So If "Customer & Code & Product & Status" appear in the list of data...