Please implement COUNTUNIQUE
Google Sheets has a =COUNTUNIQUE formula. This isn't supported in Excel and it's very ugly to try to recreate using combinations of existing formulas. Could we please have the =COUNTUNIQUE formula supported in Excel?
Thomas K commented
In the newest version of excel office 365 can combine the formula Count with the brand new formula Unique.