On Jun 18, 11:06 pm, ramana wrote:
On Jun 19, 10:54 am, Jovan Timotijevic
wrote:
=IF(MOD(A1,4)=0,A1,"")

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...

I'm not sure why I cannot get Biff's (T Valko's) solution to work. It
seems to be the simplest, if you always want multiples of 4 from 1 to
10000, as you wrote.

If you simply want multiples of 4 from 1 to 10000 starting in B1, try:

B1: =4*row()

Copy down through B2500.

If you are starting in some other cell (e.g. B10), write:

B10: =4*(row()-row($B$10)+1)

If you want a more general solution, please clarify the general
problem that you want to solve. For example, multiples of 4 from any
set of 10000 numbers, monotonically increasing, but not necessarily
sequential, in column A.