Hi, I was wondering of there was a way to take all the unique values out of a range of data and input them into another range.
For example I'll have a list of 1-2000 in one column which can have up to 11 different values in it. These will not be numerical values mind you just 1-11 different words. What I need to do is have another column just populated by the unique values so that I can draw off that for other formulas in the sheet. I just want it to autopopulate when the user puts in their raw data.
Bookmarks