OK....The problem must be with your workbook, so...just to test:
Copy/Paste the formula into a NEW, BLANK worksheet
Then put some numbers in the E6:W6 range.

=AVERAGE(LARGE(E6:W6,{1,2,3}))

Does it work in that situation?

***********
Regards,
Ron


"Belzbub" wrote:

Nope, when the message pop up and i press enter, "W6," in the formula is
marked...

Ron Coderre skrev:

Nah...don't send the worksheet...

Just copy the below formula
(paint through it using your mouse then right click and select Copy)
=AVERAGE(LARGE(E6:W6,{1,2,3}))

Then, click on any cell on your worksheet that is NOT in row 6.
Right click and select Paste.

Does that help?

***********
Regards,
Ron