Don't have the patience to continue here:

https://www.excelforum.com/excel-for...nt-groups.html

Formula solution required.