Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help creating list of Reoccuring names
Hello i need help in what formula or best way it would be to create a seperate list from several, on a number of my sheets that will display all names that have occured more than once. can anyone help. -- Alphabet ------------------------------------------------------------------------ Alphabet's Profile: http://www.excelforum.com/member.php...o&userid=30180 View this thread: http://www.excelforum.com/showthread...hreadid=498626 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help creating list of Reoccuring names
Here is one way, but it does show all of the repetitions as well
Select a range of cells in an adjacent column. Then in the formula bar enter =IF(ISERROR(SMALL(IF(COUNTIF($A$1:$A$20,$A$1:$A$20 )1,ROW($A1:$A20),""),ROW( $A1:$A20))),"", INDEX($A$1:$A$20,SMALL(IF(COUNTIF($A$1:$A$20,$A$1: $A$20)1,ROW($A1:$A20),"") ,ROW($A1:$A20)))) and commit with Ctrl-Shift-Enter. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Alphabet" wrote in message ... Hello i need help in what formula or best way it would be to create a seperate list from several, on a number of my sheets that will display all names that have occured more than once. can anyone help. -- Alphabet ------------------------------------------------------------------------ Alphabet's Profile: http://www.excelforum.com/member.php...o&userid=30180 View this thread: http://www.excelforum.com/showthread...hreadid=498626 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating custom list with a comma in it | Excel Discussion (Misc queries) | |||
Creating an invoice with a lookup list | Excel Discussion (Misc queries) | |||
Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
How do I find a name in a list of names? | Excel Worksheet Functions | |||
How do I put a list of names and e-mail addresses in excel so tha. | Excel Discussion (Misc queries) |