Hello all! Question here,
I have a data set with a lot of rows. Each row has a department. There are only 5 departments so a lot of rows have the same department.
If you were to put a filter on the department column you would see the Five departments. Is there a formula that can return the five departments in another sheet say in cells A1:A5?
Thanks!!!
Bookmarks