Forum Discussion
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ür mich?
Danke im Voraus!!
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?
6 Replies
=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.
Does it work in the attached file?
