This content has been marked as final. Show 2 replies
I have a series of customers with historical sales for prior month, and each customer has varying expiration dates. What I'm trying to do is populate the 12 months following each customer's expiration month with the values from the previous 12 months. I'm thinking it's a simple formula but I haven't nailed it yet. I have a sample data set attached.