Hello
I am trying to display the value written in the current month, in another cell. So when its July, i want the value that is written in the table, under juli, to be displayed in another tabel below. Like this:
So that the data in July (97,00%) is displayed in the marked cell (Below "Status på mål").
What i have used for the YTD is this: =AVERAGE(OFFSET(E6;0;0;1;MATCH(C22;Tabel12[[#Headers];[Januar]:[December]];0))) ,but i dont want it to average, i only want the show the current value in the current month.
I thought i might tweak this in a way, but i cant really come up with a solution..
I hope it makes sense and that someone can help me with this!
Thanks!
I am trying to display the value written in the current month, in another cell. So when its July, i want the value that is written in the table, under juli, to be displayed in another tabel below. Like this:
So that the data in July (97,00%) is displayed in the marked cell (Below "Status på mål").
What i have used for the YTD is this: =AVERAGE(OFFSET(E6;0;0;1;MATCH(C22;Tabel12[[#Headers];[Januar]:[December]];0))) ,but i dont want it to average, i only want the show the current value in the current month.
I thought i might tweak this in a way, but i cant really come up with a solution..
I hope it makes sense and that someone can help me with this!
Thanks!