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
|