| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return a list of names, from a large list of repeated names. | Excel Worksheet Functions | |||
| Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
| create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
| using conditional formatting to mark repeated names in list? | Excel Discussion (Misc queries) | |||
| How to make a chart from a list of names? | Charts and Charting in Excel | |||
Linear Mode
