Thanks Luke and Hui....yes i know it can be done via Macro but i dont want to use Macro as it already a huge file and i dont want to make it more heavy...so just asking if it is possible via any formula...in that case i can just add this new formula....but no worries thanks for advising