Hello, how do I remove the duplicates in the data validation on column B?
I read about =SORT(UNIQUE for O365 however that's not showing up for me. (Maybe because I am using O365 Plus Pro?)
Attached is the sample file.
thank you
Hello, how do I remove the duplicates in the data validation on column B?
I read about =SORT(UNIQUE for O365 however that's not showing up for me. (Maybe because I am using O365 Plus Pro?)
Attached is the sample file.
thank you