count unique numbers in array

[MetLife]

Hi,

I have a column of integers, from A1:A1000. Some of the integers repeat. I know how to use data -> remove duplicates. But all I really want to do is create a formula, if possible, that counts the unique integers.

Is this possible?

Thanks,

 

[Fluff]

How about

=rows(unique(a1:a1000))

 

[MetLife]

How about

=rows(unique(a1:a1000))

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.