Forum Discussion
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
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