First of all greetings to everyone. This is my first post, but i am following this forum for a long time and i found a lot of answers here
But now i have a specific question where i didn't find an answer here, so please help if you know how to make it work.
I have a large table with a lot of values where i have to compare the values from each month. I have written all the formulas that i need and everything i working ok.. Now i have all the formula fixed based on column number(column A,b,c,d...), but the problem is that the months won't be always in the same columns.
So i would need a formula like this: Where the call value matches "Mar" execute some sample formula, where the call value matches "Jun" execute another formula and so on....
<tbody>
</tbody>
Hope i wrote it clearly enough...
Thanks for any help.
But now i have a specific question where i didn't find an answer here, so please help if you know how to make it work.
I have a large table with a lot of values where i have to compare the values from each month. I have written all the formulas that i need and everything i working ok.. Now i have all the formula fixed based on column number(column A,b,c,d...), but the problem is that the months won't be always in the same columns.
So i would need a formula like this: Where the call value matches "Mar" execute some sample formula, where the call value matches "Jun" execute another formula and so on....
Jan | Feb | Mar | Apr | Maj | Jun | Jul | Avg | Sep | Okt | Nov | Dec | |
test | 1 | 2 | -3 | 4 | 5 | 6 | 7 | 8 | -5 | 10 | 11 | 12 |
test1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
test2 | 1 | 2 | 3 | 4 | -5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
test3 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
test4 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
test5 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
test6 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
test7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
test8 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
test9 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
test10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
test11 | 1 | 2 | 3 | 4 | 5 | 6 | -7 | 8 | 9 | 10 | 11 | 12 |
test12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
test13 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
<tbody>
</tbody>
Hope i wrote it clearly enough...
Thanks for any help.