Unique data
Hi Alam
If you are looking to generate a unique list you can use Autofilter option..
1. Select the range in Col A including the header. You need to have header
for ColA
2. From menu DataFilterAdvanced FilterCopy to another location
3. In copy to I have selected G1 and check 'Unique records only'
4. Click OK will give you the unique list in Col G
If this post helps click Yes
---------------
Jacob Skaria
"Shah Alam" wrote:
Dear Experts,
Suppose,
'Col A' has a lot of text data, how can i find it out the duplicate data.
thanks
|