getting numbers that are divisible by 4

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ramana - 19 Jun 2007 06:19 GMT

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

Reply to this Message

T. Valko - 19 Jun 2007 06:52 GMT

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

> Hi evebody,
>
[quoted text clipped - 7 lines]
>
> Ramana

Reply to this Message

Jovan Timotijevic - 19 Jun 2007 06:54 GMT

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

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

Reply to this Message

ramana - 19 Jun 2007 07:06 GMT

On Jun 19, 10:54 am, Jovan Timotijevic
<JovanTimotije...@discussions.microsoft.com> 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

Reply to this Message

joeu2004 - 19 Jun 2007 08:18 GMT

> On Jun 19, 10:54 am, Jovan Timotijevic
> <JovanTimotije...@discussions.microsoft.com> wrote:
[quoted text clipped - 4 lines]
> 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.

Reply to this Message