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
=INDEX($A$2:$A$4500,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$4500),0,0),0))

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