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...
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")
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.