MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET

[r.kordahi]

i have a list of names as
robert
paul
martin
edwin
robert
paul
martin
edwin
marc
rony
i need a list how will display the names listed and only once the repeated
names or

 

[mikebres]

One way would be to create a copy using the Advanced Filter. See link

http://www.contextures.com/xladvfilter01.html#FilterUR

 

[FARAZ QURESHI]

On the cell to the right of the very first name enter:

=IF(COUNTIF(INDIRECT(ADDRESS(ROW()-ROW()+1,COLUMN()-1,4)&":"&ADDRESS(ROW(),COLUMN()-1,2)),INDIRECT(ADDRESS(ROW(),COLUMN()-1),4))>1,"",INDIRECT(ADDRESS(ROW(),COLUMN()-1)))

Copy down the same as much as you require;

Select the resulting cells with formulas;

Press Ctrl+C;

Press Alt+E, then S, then V and then Hit Enter;

Finally sort the new list to remove the Blanks.