Thanks for the quick reply
I want to solve this problem by vba not formulas