Oversettelse av Engelsk formel

[JanB]

Har fått hjelp med mitt problem, men den formelen jeg fikk er på engelsk og
kan ikke skrives slik i en Norsk Excel
=AVERAGE(LARGE(MOD(COLUMN(A1:M1),2)*A1:M1,ROW(INDIRECT("1:5"))))

Kan noen hjelpe med å oversette den?

 

[Mike H]

Hi,

No need to start another thread. I'm not sure if you use , or ; but I think
this is the Norwegian translation.

=GJENNOMSNITT(N.STØRST(REST(KOLONNE(A1:M1),2)*A1:M1,RAD(INDIREKTE("1:5"))))


Mike

 

[JanB]

Still wrong Mike
I have now changed some "." into ";" to not get the error dialog box.

=GJENNOMSNITT(N.STØRST(REST(KOLONNE(A1:M1);2)*A1:M1;RAD(INDIREKTE("1:5"))))

It would not work

JanB
Mike H skrev:

 

[Mike H]

Hi,

Did you array enter it?

Mike

Still wrong Mike
I have now changed some "." into ";" to not get the error dialog box.

=GJENNOMSNITT(N.STØRST(REST(KOLONNE(A1:M1);2)*A1:M1;RAD(INDIREKTE("1:5"))))

It would not work

JanB
Mike H skrev:

 

[Niek Otten]

<would not work>

What happens?

 

[JanB]

=GJENNOMSNITT(N.STØRST(REST(KOLONNE(A1:M1);2)*A1:M1;RAD(INDIREKTE("1:5"))))
I get Cell with ###
The info box says: One value that is used in the formula is wrong datatype

(I have tried to translate the Norwegian message)

JanB

Niek Otten skrev:

 

[Mike H]

Hi,

The first and most obvious check. Is the cell wide enough to display the
result?

Do you have any text cells in the range? Note that despite only working on
numbers in 'odd' columns the formula still checks 'even' columns so you can't
have text in any cell in the range.

Mike

 

[JanB]

When I expand the cell with the formula is says: "#Value!"
I have no text in either cell in the row/range of cells
I have tried both with og without numbers in B,D,F ....
JanB

Mike H skrev:

 

[Mike H]

Hi,

The only way I can make it return a value error is with text in the range.
All cells in the range must be numeric

Mike