|I'm glad you found a solution that works for you. |
It can get really confusing (and annoying) when certain functions only work on certain platforms and/or specific versions. For example, the FLOOR.MATH function is apparently only available as follows:
Excel 2016, Excel 2013, Excel 2016 for Mac, Excel for Mac 2011, Excel Online, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
I have 2013 for Windows at home and 2010 for Windows at work. That means that I probably couldn't use your workbook at work. (I was unable to test your solution on my 2010 version) That might be something to keep in mind if people with other platforms/versions need to use your workbook.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.