Forum Discussion
multiple cells into 1
When you copy a formula down, a relative cell reference like =A1 will be incremented by one row only, to return =A2. Excel does not recognize a pattern and will not apply a pattern.
There are several other things you could do.
Split the structure number into two columns, so that one column has only the number and the other one has the text.
- now you can build a pivot table that totals all values for the same structure number
- or use Sumif functions or the new Dynamic Array formulas currently only available in Office 365 Insider.
When you copy a formula down, a relative cell reference like =A1 will be incremented by one row only, to return =A2. Excel does not recognize a pattern and will not apply a pattern.
There are several other things you could do.
Split the structure number into two columns, so that one column has only the number and the other one has the text.
- now you can build a pivot table that totals all values for the same structure number
- or use Sumif functions or the new Dynamic Array formulas currently only available in Office 365 Insider.