Hi daffodil11,

Sorry for confusion. When I posted the thread, it got messed up.

I have created image of spread sheet for example. Attached. Could someone please see if it is possible to do something like this without macro.

Kamlesh.excel problem.png