Forum Discussion
hurshie
Jun 04, 2020Copper Contributor
EXCEL FORMULA HELP
Hello, I am trying to count headcount but cant seem to count unique values. example: Below is the text that i need a countif headcount and i cant seem to get unique values. If there are dupli...
Jun 04, 2020
hurshie You tagged the question with "Office 365". What did you mean with that? If you have Office 365, you should have the UNIQUE() function. If you don't have Office 365, why did you use that tag???
Then again, why did you tag with "Admin" and "BI & Data Analysis", "Developer" and "Excel for web". Why?
Tags have a purpose. They're meant to identify what the problem is about. They're not collectables.
Jos_Woolley
Jun 04, 2020Iron Contributor
Perhaps the OP requires that the file in question be workable in the desktop version of Excel. I have Office 365, though functions such as UNIQUE, FILTER, etc. have not yet been rolled out as part of my subscription; as such, I have to use (and remain in) Excel Online when I want to employ those functions.
Regards