Return value furthest to the right in a row

[eirikdaude]

Putting the formula

=IFERROR(INDEX(Karbon[@[Januar]:[Desember]];1;COUNTA(Karbon[@[Januar]:[Desember]]));1)

results in a spill-error in the table below, when there are no entries in the columns I'm looking at, I assume because index returns all the columns when it gets 0 as the argument for the number of columns or something like that?
Is there some better way to get the entry furthest to the right in the a given range / row?

 

[Fluff]

How about

=TAKE(FILTER(Karbon[@[Januar]:[Desember]];Karbon[@[Januar]:[Desember]]<>0);;-1)

 

[Fluff]

Forgot the error handling

=TAKE(FILTER(Karbon[@[Januar]:[Desember]];Karbon[@[Januar]:[Desember]]<>0,"");;-1)

 

[eirikdaude]

Forgot the error handling

=TAKE(FILTER(Karbon[@[Januar]:[Desember]];Karbon[@[Januar]:[Desember]]<>0,"");;-1)

Yeah, I think this would have worked perfectly from what I am reading, but unfortunately my workplace updates Office a bit too rarely for it to be a solution yet. We're still on V2108, while TAKE is only included in V2208 and later.

I think I should be able to come up with a solution based on the filter-function you show anyway, so thanks for the help!

 

[Fluff]

Ok, how about

=let(f;FILTER(Karbon[@[Januar]:[Desember]];Karbon[@[Januar]:[Desember]]<>0,"");index(f;;columns(f)))

 

[eirikdaude]

Works like a charm, and thanks for showing me how to store the result array in a variable - I would have used the filter function twice for sure!

 

[Fluff]

You're welcome & thanks for the feedback.