How to add a Matricial formula in a Cell?

27 views

Skip to first unread message

Alfredo Pingarrón

unread,

Feb 23, 2015, 2:36:46 PM2/23/15

to ax...@googlegroups.com

Hello there!

In some SpreadSheet readers (Google Docs) I can use '=COUNTUNIQUE(A1:Ax)' and get the count of unique elements. In others (MSOffice) this function does not exists! So I need to add a Matricial formula, a formula with a '{}' around it, but this is only valid in Excel if you press Ctrl+Shift+Enter in the Cell. How can I do that with AXLSX?