On Jun 19, 10:54 am, Jovan Timotijevic
wrote:
Enter this formula in B1 and double click on fill handler to copy it 10000
rows below.

=IF(MOD(A1,4)=0,A1,"")

Hi Jovan,

Thank you for giving the reply, I have already tried what you
have suggested, I'm getting the value in every 4th row, remaining are
blank, but I need in continuous cells. i.e. in the first row it should
be 4 second row 8 third row 12 and so on...

Thanks and Regards

Ramana