Forum Discussion
Counting unique entries and creating a list
There are several ways to achieve that.
One easy way is, you can insert a Pivot Table and drag the same field you are trying to count the unique occurrences in both the Rows area and the Values area and change the value field setting to Count if the column you are working contains the numeric data.
I also think that you should have started your own question as it would be irritating for the OP as he/she might be getting all the notifications of replies being posted here and specially when the question has been marked as Solved.
Thanks Subodh_Tiwari_sktneer . I downloaded the spreadsheet and opened it in Excel and, as previously from Sergei, the formula cell B2 contains "=_xlfn.UNIQUE(A2:A10)". If I click on B2, "{=_xlfn.UNIQUE(A2:A10)}" is actually displayed in the formula bar, but if I click there, the braces { and } dissapear.
Thanks SergeiBaklan and @Subodh_Tiwari_sktneer for persevering with this issue. It is unfortunate that the version of Excel I have doesn't complain about the "=UNIQUE()" formula. THat at least would provide a clear indication of the issue.
Yes, I agree with Subodh_Tiwari_sktneer , Dynamic Arrays and all related functions, UNIQUE in particular, are not available for your version. To my knowledge they are deployed only for Insiders Fast and Monthly Targeted channel, not for Monthly channel.
That simply means you don't have access to the dynamic array functions yet.
Join the Office Insider program from your Account page and keep on updating the Office until you have access to the dynamic formulas.
