Danny

[dannyvant]

Hi,


I am having issues with my array formula on repeat occurring data. I only want to count this data once and really need a simple formula to do this.


Can anybody please help!!!!


Thanks in advance

 

[Luke M]

Welcome to the forum. To get better help on your post:

1. Give a short, concise subject line to your thread

2. Describe what your problem is

3. Post a sample/example of your data; what it looks like now, what's you'd like to see

4. Post what you've already tried (if applicable)

5. Be considerate, and post links to other forums you may have cross-posted to (if applicable)


You problem description currently is VERY vague, but a initial guess is that you want to count uniques. In helper column 1:

=COUNTIF($A$1:A2,A1)

Copy down as needed


Count of uniques:

=COUNTIF(HelperColumn1,1)