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?

     
     
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?

       
       
      • NoelleF2000's avatar
        NoelleF2000
        Copper Contributor
        May 04, 2022
        Noo I didn't. It worked now 🙂 Thank you so much!!!