Forum Discussion
Copy a formula horiztonally (Row 1") that references text in only one column "Column A"
I have an excel sheet with text in Column A. I have a formula that I need to copy and paste on the first row (D1, F1, H1, J1, L1...) the formula references text only in column A (A1, A2, A3, A4, A5...
=IF(ISEVEN(COLUMN()),INDEX($A:$A,QUOTIENT(COLUMN(B$2),2)),"")This formula returns the intended result in my sheet.
- Thank you! I will have to try these formulas to see if I get the same results.
Where would I place the above formula in my forumula? Do I replace A1? This is my formula:
D1=@BDH(A1,"SALES_REV_TURN", "-40ay","","per=Q","cols=2;rows=32")
F1=@BDH(A2,"SALES_REV_TURN", "-40ay","","per=Q","cols=2;rows=32")
