Forum Discussion
jcasqueiro
Mar 13, 2020Brass Contributor
Replicating a column based on the content of a cell (that acts like a filter)
Hi, I have a table with monthly values like: jan feb mar 2 3 2 4 5 6 and I want to add a column that replicates one of the monthly cols based on a cell with the c...
Riny_van_Eekelen
Mar 13, 2020Platinum Contributor
- jprcasqueiro01Mar 13, 2020Copper Contributor
Thanks
- jprcasqueiro01Mar 13, 2020Copper Contributor
@Riny
It works fine but I had to put ROW()-1 otherwise it would give me the value in the correct column but in the row below...... really strange.
Thanks/Brgds
j