You don't have to do anything. I was posing a possible answer based on a somewhat "open" description of your problem.

If you look at your description of the problem, I think you'll find there is no mention of the structure of your workbook, the layout of the sheets, the location of data and formulae, or the formulae themselves.

I was trying to be helpful without just saying "please post a workbook". Clearly, I should have said just that.

If you don't understand the formula that I have suggested, what it does or where it should go, you shouldn't just type it in. I'm guessing it will need some modification.

Regards, TMS