Forum Discussion

NoelleF2000's avatar
NoelleF2000
Copper Contributor
May 04, 2022
Solved

Häufigkeitsfunktion

Die Häufigkeitsfunktion bei Excel auf meinem Macbook funktioniert trotz Matrixformel nicht. Wenn ich die erste Spalte runterziehe, kommen nur noch falsche Werte raus.  Haben Sie irgendwelche Tipps f...
excel
Excel on Mac
  • OliverScheurich's avatar
    OliverScheurich
    May 04, 2022

    NoelleF2000 

    You are welcome. That's surprising. In Excel 2013 it works as expected as you can see in the attached pdf. file. In your file i can see the correct results in range F12:F16.

     

    Did you select the full range (like in the attached file) before pressing ctrl+shift+enter?

     
     
OliverScheurich's avatar
OliverScheurich
Gold Contributor
May 04, 2022

NoelleF2000 

=FREQUENCY($J$2:$J$77,$K$93:$K$97)

You can try to enter the formula with dollar signs for example: $J$2:$J$77 and $K$93:$K$97.

 

Then you can copy the formula down from cell L93 to L97 and with the range L93:L97 selected you can confirm the formula with ctrl+shift+enter.

NoelleF2000's avatar
NoelleF2000
Copper Contributor
May 04, 2022

OliverScheurich 

 

Unfortunately, it still does not work. It looks like that now.

 

    • NoelleF2000's avatar
      NoelleF2000
      Copper Contributor
      May 04, 2022

      OliverScheurich 

       

      Thank you for your help! But in the attached file it does not work either.

      • OliverScheurich's avatar
        OliverScheurich
        Gold Contributor
        May 04, 2022

        NoelleF2000 

        You are welcome. That's surprising. In Excel 2013 it works as expected as you can see in the attached pdf. file. In your file i can see the correct results in range F12:F16.

         

        Did you select the full range (like in the attached file) before pressing ctrl+shift+enter?