Find unique values from range ( populated cells only) & not count zeros or NA errors VBA

Hi all,
Earlier I was trying to find if unique values could be found using many methods by using formula.Range is from A2:A4500 .
It works fine. ThirtyTwo gave me a good solution. Please refer my thread :

http://www.excelforum.com/excel-prog...ml#post3659772

Index code also can be used and works fine

Please Login or Register  to view this content.

This gives me three challenges:
1. It takes a while to go through A2:4500 and makes process slow
2. It also counts zeros or may give NA error
3. In the list of unique values the list is separated by value ' zero' that it has counted as one of the unique values

To find solution I need help please.

1. Need to look at A2:A4500 only at the populated cells with text ( not with zeros or NA error)
2. It does not count zeros or na values

Can we consider VBA or Formula and if so what it will be.

Need some help or hint please to understand this issue

Many thanks
Kind regards

You can include iferror with the formula which will get rid of N/A. An alternative code is attached.

Please Login or Register  to view this content.

Hi AB33,
This sounds very cool.
It has got rid of zeros, NA errors and the rest.
Simple, original and best solution.
Thanks again
kind regards