I was trying to make these {"MOOE-LIQUIDATED","MOOE-DOWNLOADED","GAD-LIQUIDATED","CANCELLED"} to be inputted with Cell reference on A1, A2, A3, A4 but it gives me error if I change it.
If you have continius range then {A1,A2,A3,A4} is A1:A4
Or you can use CHOOSE({1,2,3,4},A1,A2,A3,A4).
Last one could be use for any set such as A1,C22,D34,V45
CHOOSE({1,2,3,4},A1,C22,D34,V45)
Please use appropriate separator for horizontal or vertical array.
Bookmarks