February 19, 2021
I need to make Excel Power Query in one column the sums of to columns and in another column i need to subtract them.
I cannot use the names of the columns because they change with every refresh.
So i want to know if it is possible to makes calculation in Power Excel without using the names of the column.
i think something like in Excel Column C + Column D and Column C minus Column D
So that the formula's stays correct if the Column names changes.
Is this possible ? If yes how can i do this ?
July 16, 2010
You can refer to columns by position as explained here.