Dec 09 2020 02:48 AM - edited Dec 09 2020 03:09 AM
I tried to find a formula or a macro for this online but I couldn't find anything.
I need a way to calculate the consecutive numbers in a comma separated list.
Please see the attached file for sample data and expected results.
Thanks in advance.
I'm using Excel 2016.
* In the sample file, I put the expected results in separate cells, but it can be in a single too.