Excel shortcut keys "Frequency" function

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?ui=en-us&rs=en-us&ad=us

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/e178f9a2-bb3e-4a06-8c2b-e9ff96ffca10

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.