Excel shortcut keys "Frequency" function

%3CLINGO-SUB%20id%3D%22lingo-sub-1895550%22%20slang%3D%22de-DE%22%3EExcel%20shortcut%20keys%20%22Frequency%22%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1895550%22%20slang%3D%22de-DE%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3EI'm%20currently%20working%20on%20an%20assignment%20for%20university%20which%20requires%20me%20to%20create%20a%20frequency-table.%20As%20it%20specifies%20the%20formula%2C%20I%20don't%20think%20that%20using%20other%20ways%20to%20solve%20it%20are%20wanted...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20entering%20the%20necessery%20information%20for%20data%20and%20bins%20I'm%20supposed%20to%20use%20the%20shortcut%20Control%20%2B%20shift%20%2B%20enter.%20Most%20of%20the%20time%20these%20deletes%20my%20entry%20for%20either%20data%20or%20bins%20or%20gives%20me%20the%20number%20%221%22%20for%20the%20first%20marked%20cell%20and%20leaves%20the%20other%20blank%2C%20considering%20which%20my%20data%2C%20does%20not%20make%20any%20sense.%20%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20far%20as%20google%20told%20me%2C%20the%20problem%20is%20that%20the%20curly%20brackets%20are%20not%20created%20and%20therefore%20excel%20doesn't%20create%20the%20matrix.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20working%20with%20Excel%20version%2016.16.27%20for%20Mac%20and%20have%20talked%20to%20some%20of%20my%20friends%20who%20are%20in%20the%20same%20class.%20It%20seems%20like%20this%20is%20a%20problem%20that%20only%20occurs%20for%20Mac%20users.%3C%2FP%3E%3CP%3EA%20fix%20for%20it%2C%20some%20of%20my%20friends%20found%2C%20is%20to%20buy%20the%20newest%20Excel%20version%20where%20you%20can%20simply%20click%20on%20%22complete%22%20to%20finish%20the%20formula.%20I'm%20not%20really%20willing%20to%20donate%20money%20to%20fix%20such%20a%20problem...%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20a%20different%20shortcut%20or%20solution%20to%20my%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20a%20native%20speaker%20and%20am%20using%20a%20non-English%20version%20of%20excel.%20If%20anything%20is%20unclear%20please%20let%20me%20know%20and%20I%20will%20try%20to%20specify.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1895550%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1896867%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20shortcut%20keys%20%22Frequency%22%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1896867%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F871873%22%20target%3D%22_blank%22%3E%40lenaev%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAs%20for%20excel%20for%20mac%2C%20my%20knowledge%20is%2C%20to%20put%20it%20mildly%2C%20very%20limited.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EBut%20send%20you%20this%20information%2C%20it%20may%20help%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EOr%20a%20Mac%20specialist%20will%20see%20your%20post%20again%20and%20may%20have%20a%20solution%20that%20can%20help%20you%3A).%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EFREQUENCY%20function%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffrequency-function-44e3be2b-eca0-42cd-a3f7-fd9ea898fdb9%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffrequency-function-44e3be2b-eca0-42cd-a3f7-fd9ea898fdb9%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%26nbsp%3BIf%20you%20have%20a%20current%20version%20of%20%3CA%20href%3D%22https%3A%2F%2Fproducts.office.com%2Fen-us%2Fbuy%2Fcompare-microsoft-office-products%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20365%3C%2FA%3E%2C%20then%20you%20can%20simply%20enter%20the%20formula%20in%20the%20top-left-cell%20of%20the%20output%20range%2C%20then%20press%20%3CSTRONG%3EENTER%3C%2FSTRONG%3E%20to%20confirm%20the%20formula%20as%20a%20dynamic%20%3CSTRONG%3Earray%20formula%3C%2FSTRONG%3E.%20Otherwise%2C%20the%20formula%20must%20be%20entered%20as%20a%20%3CSTRONG%3Elegacy%20array%20formula%3C%2FSTRONG%3E%20by%20first%20selecting%20the%20output%20range%2C%20entering%20the%20formula%20in%20the%20top-left-cell%20of%20the%20output%20range%2C%20and%20then%20pressing%20%3CSTRONG%3ECTRL%2BSHIFT%2BENTER%3C%2FSTRONG%3E%20to%20confirm%20it.%20Excel%20inserts%20curly%20brackets%20at%20the%20beginning%20and%20end%20of%20the%20formula%20for%20you.%20For%20more%20information%20on%20array%20formulas%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fguidelines-and-examples-of-array-formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EGuidelines%20and%20examples%20of%20array%20formulas%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EHow%20to%20Use%20Array%20Formula%20in%20Excel%20Mac%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fhow-to-use-array-formula-in-excel-mac%2Fe178f9a2-bb3e-4a06-8c2b-e9ff96ffca10%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fhow-to-use-array-formula-in-excel-mac%2Fe178f9a2-bb3e-4a06-8c2b-e9ff96ffca10%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20could%20help%20you%20at%20least%20a%20little.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello!

I'm currently working on an assignment for university which requires me to create a frequency-table. As it specifies the formula, I don't think that using other ways to solve it are wanted...

 

After entering the necessery information for data and bins I'm supposed to use the shortcut Control + shift + enter. Most of the time this deletes my entry for either data or bins or gives me the number "1" for the first marked cell and leaves the other blank, which considering my data, doesn't make any sense.  

As far as google told me, the problem is that the curly brackets { and } are not created and therefore excel doesn't create the matrix.

 

I'm working with Excel version 16.16.27 for Mac and have talked to some of my friends who are in the same class. It seems like this is a problem that only occurs for Mac users.

A fix for it, some of my friends found, is to buy the newest Excel version where you can simply click on "complete" to finish the formula. I'm not really willing to spend money to fix such a problem...

Does anyone know a different shortcut or solution to my problem?

 

 

I'm not a native speaker and am using a non English version of excel. If anything is unclear please let me know and I will try to specify. 

2 Replies
Highlighted

@lenaev 

As for excel for mac, my knowledge is, to put it mildly, very limited. But send you this information, it may help you.

Or a Mac specialist will see your post again and may have a solution that can help you:).

 

FREQUENCY function

https://support.microsoft.com/en-us/office/frequency-function-44e3be2b-eca0-42cd-a3f7-fd9ea898fdb9?u...

Note: If you have a current version of Microsoft 365, then you can simply enter the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, entering the formula in the top-left-cell of the output range, and then pressing CTRL+SHIFT+ENTER to confirm it. Excel inserts curly brackets at the beginning and end of the formula for you. For more information on array formulas, see Guidelines and examples of array formulas.

 

How to Use Array Formula in Excel Mac

https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-use-array-formula-in-excel-mac/e178f9a...

 

Hope I could help you at least a little.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Highlighted

@Nikolino 

Hi Nikolino,

Thank you for answering! 

I've already seen the page you send me and unfortunately don't have the newest Microsoft 365 version.

I've also already talked to Microsoft support, who couldn't help me as well and refered me to this forum...

Still, thanks for looking that up for me!