Forum

Is it possible to c...
 
Notifications
Clear all

Is it possible to calculate without using the columns names but relative positions

2 Posts
2 Users
0 Reactions
153 Views
(@marcberg)
Posts: 23
Trusted Member
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
(@mynda)
Posts: 4761
Member Admin
 

Hi Marc,

You can refer to columns by position as explained here.

Mynda

 
Posted : 02/03/2021 8:00 pm
Share: