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...). How can I do this? Thank you!
9 Replies
A 365 solution that avoids traditional spreadsheet techniques.
= TOROW(HSTACK(list, IF(LEN(list)>0, "")))Note that E1 is part of the formula result and cannot be used to enter data.
- Thank you! 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")Sorry but I do not know what BDH(...) is supposed to do with its somewhat complicated text parameters.
An interesting formula in that it doesn't generate a spill error, but it was my intention to insert blank cells not remove them!
=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")
Kindly use Absolute Reference ($A$1).
PFB Example
Please consider giving it a 'thumbs up' if it was helpful for you. You can also show your support by subscribing to my YouTube channel, @Excelonlineadvisor, and following me on Instagram, @Excelonlineadvisor.
- Thank you. Unfortunately Absolute Reference ($A$1) did not work. A1 appear in each cell instead of A1, A2, A3...
