yes now i got my desire output , thanks for that . one issue if cell having blank it returns to #VALUE! . i don't want to see this . it should be blank as the field having no data.