I'd like to implement data validation type list from a range in a spreadsheet. Duplicates are automatically removed which is nice, but I'd also like to sort the list alphabetically. So I'm typing in range =SORT(A2:A) But I get an error message asking me to enter a valid range.
I don't understand the issue as it's specifically written: "enter a range or formula"