Forum Discussion

StefanMeier's avatar
StefanMeier
Copper Contributor
May 17, 2022

Array function is not working anymore

Dear all

I am using an array function that work so far, now it is not anymore, to be more precise, it is working in excel sheets that I made last year, using the same formula in the same excel sheet does not work anymore.

The formula is:

=INDEX($B$2:$B$11;KGRÖSSTE(($A$2:$A$11=$F$1)*(ZEILE($A$2:$A$11)-1);ZÄHLENWENN($A$2:$A$11;$F$1)+1-ZEILE(A1)))

(it's in german i know...)

 

 

I am working on a company computer. Maybe some settings were changed by company policy, I don't know, So far nobody was able to help me.

 

I also tried to do this on Excel online, but there I cannot insert array functions.

 

Here a link to an example file:

https://www.herber.de/bbs/user/153111.xlsx

5 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    StefanMeier See if the attached file works for you. In E4:F7 I used your formula, but since you tagged your post with Office365, you may want to use the Filter function as demonstrated in cell I4.

    • StefanMeier's avatar
      StefanMeier
      Copper Contributor
      Thanks a lot, your solution is working perfect for me!

      Even my formula is working in your sheet, but why?