list of array functions

[lezawang]

Hi
I just watched a video in which he said Transpose() is an array function. I tried to google list of array functions in excel but all what I go how to use CTRL+Shift+Enter to make array formula. My question, are they functions in excel called array functions? or array can be used with any function by using ctrl+shift+enter? Thank you.

 

[RasGhul]

Mr Excel, Excelisfun & Leila Gharani do many great videos to learn from with solutions and explanations of common Excel problems...

https://www.youtube.com/watch?v=RDP1uF7HafU

 

[Aladin Akyurek]

Hi
I just watched a video in which he said Transpose() is an array function. I tried to google list of array functions in excel but all what I go how to use CTRL+Shift+Enter to make array formula. My question, are they functions in excel called array functions? or array can be used with any function by using ctrl+shift+enter? Thank you.

When we need an array-processing formula, we need in the current versions to signal this fact to Excel by means of control+shift+enter. Exceptions to this rule occur when we invoke functions which by design are array-processing functions like SUMPRODUCT, LOOKUP, or FREQUENCY. Even the formulas constructed with these functions might require control+shift+enter when they are paired with IF, TRANSPOSE, etc.