I've been using MrExcel tips for years and I appreciate all the assistance I've received from this website.
I saw that a spreadsheet had been created for users of Office365 and it inspired me to create one that is compatible with 2016.
It uses formulas and one custom function (to eliminate multiple letters from the yellow section).
I don't know if it's allowed to share our work here, but I'd love to get input from other users, especially if they know of ways to shorten some of my formulas to make the spreadsheet run faster.
If this type of post isn't allowed, please remove it and let me know. If it is allowed and someone wants to give it a whirl, let me know and I'll share it (via Google Drive).
I saw that a spreadsheet had been created for users of Office365 and it inspired me to create one that is compatible with 2016.
It uses formulas and one custom function (to eliminate multiple letters from the yellow section).
I don't know if it's allowed to share our work here, but I'd love to get input from other users, especially if they know of ways to shorten some of my formulas to make the spreadsheet run faster.
If this type of post isn't allowed, please remove it and let me know. If it is allowed and someone wants to give it a whirl, let me know and I'll share it (via Google Drive).
