getting numbers that are divisible by 4
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 |
getting numbers that are divisible by 4
Here's one way:
Enter 4 in B1 Select B1 Goto the menu EditFillSeries Select Columns and Linear Step value 4 Stop value 10000 OK Biff "ramana" wrote in message oups.com... 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 |
getting numbers that are divisible by 4
Enter this formula in B1 and double click on fill handler to copy it 10000 rows below. =IF(MOD(A1,4)=0,A1,"") |
getting numbers that are divisible by 4
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 |
getting numbers that are divisible by 4
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. |
All times are GMT +1. The time now is 01:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com