https://www.excelforum.com/excel-for...worksheet.html

OP looking for a Formula Based Solution. I have provided a workable VBA. This is beyond my Formula Skills.