Can you restate your problem - how are values "encountered" ?
Are you looking for a custom function ?

Tim

"Vikas_Yadav" wrote in message
...
idea is to implement a simple logic,in a column the cell has to
return the
same value which had been encountered first untill the next value is
encountered after which the new value encountere should be returned.