Apr 03 2020 06:22 AM
Apr 03 2020 07:22 AM
Solution@AL789 I solved this with an array formula in the attached. In pre-Office 365 you would have to press Ctrl Shift Enter to confirm this type of formula after entering it.
Apr 03 2020 07:22 AM
Solution@AL789 I solved this with an array formula in the attached. In pre-Office 365 you would have to press Ctrl Shift Enter to confirm this type of formula after entering it.