All,
I am looking for a way to calculate the specific numbered month in a model's product life starting with 1. EX. If model ABC's first month is 2/2013, I would like for that to be listed as 1, 3/2013 would be 2, 2/2014 would be 13 and so on. My data contains roughly 100,000 lines and 200 models with everything being spread out. Attached is a basic version of what I am looking to accomplish.
If you have any questions, please let me know. Thank you in advance.
Bookmarks