Hi Marcol, Thanks for your help on my previous problem. I have a new problem i need your help on..i have posted it in the forum under the heading" Need to show value as NA" can you please help me on this...