Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula - all odd numbers (or even?)
Hi,
I want to copy A1, A3, A5, A7 etc. into a seperate column, but when I try to copy it down, it doesn't seem to recognise my odd numbers request. What formula should I use? Thanks! |
#2
|
|||
|
|||
formula - all odd numbers (or even?)
Use =INDIRECT("A"&ROW(A1)*2-1) and copy down
-- HTH RP (remove nothere from the email address if mailing direct) "Georgyneedshelp" wrote in message ... Hi, I want to copy A1, A3, A5, A7 etc. into a seperate column, but when I try to copy it down, it doesn't seem to recognise my odd numbers request. What formula should I use? Thanks! |
#3
|
|||
|
|||
formula - all odd numbers (or even?)
One way
Insert column A, Then enter number 1 in A1, 2 in A2,etc . Fill down A to cover your data. (Your data now in column B) in eg C1 =If(ISODD(A1),B1,"") Fill down column C to bottom of data. HTH "Georgyneedshelp" wrote: Hi, I want to copy A1, A3, A5, A7 etc. into a seperate column, but when I try to copy it down, it doesn't seem to recognise my odd numbers request. What formula should I use? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reapeting Numbers From A Formula | Excel Worksheet Functions | |||
Change Row Numbers in Formula with Macro | Excel Discussion (Misc queries) | |||
Re What is the formula for adding multiple numbers in a cell | Excel Discussion (Misc queries) | |||
How to add 4 of 5 highest numbers using a formula | Excel Discussion (Misc queries) | |||
Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions |