Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
153
Views
Topic starter
Hello,
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 ?
Many Thanks,
Marc.
Posted : 02/03/2021 10:17 am