Ask your question

Extract identical cells in single column

cjestis - Oct 6, 2009 7:03pm BST
Hello,

Looking for a way to extract only cells in a single column with duplicate entries.

Ex:
Deb
Deb
Mike
Ann
Ann
Ann

Extracted list would show
Deb
Deb
Ann
Ann
AnnConfiguration: Windows XP Internet Explorer 7.0, Office 2007
Read more ...
Add comment

Kioskea recommends you to read :

Counting number of times a value appears if..ForumOffice software
Excel FormulasForumOffice software
Compare cell a1 to entire A col in sheet2 [Solved]ForumOffice software
Merging more cells into one cellForumOffice software
Extract identical cells of 2 columns (excel)ForumOffice software
Excel Macro - Multiple Columns Into OneForumOffice software