Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unique data
Dear Experts,
Suppose, 'Col A' has a lot of text data, how can i find it out the duplicate data. thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unique data
Hi
Enter this formula in an unused column and copy down. =COUNTIF(A:A;A1) Unique text result is one, for duplicates both entries will have the value 2 (or 3 in case of 3 identical strings). Hopes this helps. .... Per "Shah Alam" skrev i meddelelsen ... Dear Experts, Suppose, 'Col A' has a lot of text data, how can i find it out the duplicate data. thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing two columns of data and return unique data in another co | Excel Discussion (Misc queries) | |||
Unique data | New Users to Excel | |||
Adding data to existing data that has a unique number in column | Excel Discussion (Misc queries) | |||
Extracting Data for .Txt Files By Unique Field Data | Excel Discussion (Misc queries) | |||
find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) |