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 corresponding month, let's say D1.
If I put "jan" in D1, I would like to have column tot = column jan
jan
jan feb mar tot
2 3 2 2
4 5 6 4
feb
jan feb mar tot
2 3 2 3
4 5 6 5
I can accomplish this with Table1[@jan] for instance but how can I change the formula Table1[@month] to reflect the month that I put in D1?
Thanks/Brgds
j
3 Replies
- Riny_van_EekelenPlatinum Contributor
- jprcasqueiro01Copper Contributor
Thanks
- jprcasqueiro01Copper 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