Excel increment/decrement column

Help
1

Hi,

I am looking for an efficient way to increment a column in Excel.

I already have the cell address of the field title and I want to find the address of the cell to the left or right to it. E.g. if the cell is “D5” i want to get the address of either cell “C5” or “E5”. How do I do this? Preferably in one assign activity

2

Hi @DEATHFISH,

Here i have attached a header flow to get column name using column index, using this flow pass column index and get equivalent excel column name.

Helper_GetExcelColumnIndex.xaml (11.2 KB)