tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,201
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I'd like to use the new Unique function in excel to do this formula
"=UNIQUE(Month_Extended!H2:H1048576,FALSE,FALSE)"
except because there are blank cells i get a "0" as one of my names in the list,
can this be removed?
thanks
Tony
I'd like to use the new Unique function in excel to do this formula
"=UNIQUE(Month_Extended!H2:H1048576,FALSE,FALSE)"
except because there are blank cells i get a "0" as one of my names in the list,
can this be removed?
thanks
Tony