Excel functions which support arrays (SHIFT-CNTRL-ENTER)?

[ExcelMonkey]

Does anybody have a list of Excel functions which do nor do not support
arrays (SHIFT-CNTRL-ENTER)?

Thanks

 

[Biff]

Here's a few that DO NOT (but should!):

Concatenate
Substitute
Rank

Biff