SS Dynamic Array Functions
TODO
TODO
RANDARRAY
SEQUENCE
SORTBY
XMATCH
FILTER
FILTER
=FILTER(A2:A99,A2:A99<>"")
Filter out blank values
SORT
SORT
=SORT(A2:A99)
Sort
UNIQUE
UNIQUE
=UNIQUE(A2:A99)
Remove repeated values
Bibliography
Bibliography
https://exceljet.net/dynamic-array-formulas-in-excelhttps://www.statology.org/count-frequency-of-text-in-excel/https://superuser.com/questions/49614/how-do-i-get-the-distinct-unique-values-in-a-column-in-excel
ARRAYFORMULAhttps://stackoverflow.com/questions/66760820/google-sheet-issue-in-if-function-with-array-formula
ARRAYFORMULAhttps://stackoverflow.com/questions/66760820/google-sheet-issue-in-if-function-with-array-formula