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

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

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

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

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


"r.kordahi" wrote:

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

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

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.

--

Best Regards,
FARAZ A. QURESHI


"r.kordahi" wrote:

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