Range A2:D4 ... Dataset
F2: =ArrayFormula(unique(transpose(split(concatenate(A2:D4&" ")," "))))
Showing posts with label Compute Unique Values Array From Multi-Column Dataset. Show all posts
Showing posts with label Compute Unique Values Array From Multi-Column Dataset. Show all posts
Monday, January 31, 2011
Subscribe to:
Posts (Atom)