getting numbers that are divisible by 4

[ramana]

Hi evebody,

I have data(numbers) from 1 to 10000 in columnA Now I need in
column B the numbers which are divisible by 4, it looks very simple
but I'm finding it hard to get this.

Could some body help me how to do this.

Thanks and Regards

Ramana

 

[T. Valko]

Here's one way:

Enter 4 in B1

Select B1
Goto the menu Edit>Fill>Series
Select Columns and Linear
Step value 4
Stop value 10000
OK

Biff

 

[Jovan Timotijevic]

Enter this formula in B1 and double click on fill handler to copy it 10000
rows below.

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

 

[ramana]

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

 

[joeu2004]

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.