Originally Posted by p45cal The formula could be shortened more, but exactly how depends on your version of Excel. I like to have multiple solutions for any problem Anyway Thanks for both of these solutions, both of which work wonderfully.
Last edited by joky; 11-16-2023 at 03:36 PM.
Forum Rules