Terry,

Welcome to the forum.
I'm not a "Formula" person. But I know it can be done with code.
Perhaps another member with Formula knowledge can address this to you.
It may help if you can attach a redacted copy of the workbook so we get get a better ideal as to help you.