| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Filtering a list with duplicates
I need help. Is there aynone out there who can do some data tricks for me in Excel. I have a list of emails and associated account numbers. The problem is that one email may have 20+ account numbers associated with it, so I need to filter the spreadsheet to de-dupe the emails but keep all associated account numbers. Currently the sheet looks something like this: EMAIL_________ACCOUNT # ____123123 ____456789 ____789123 ____987321 But I need it to look like this: EMAIL_______ACCOUNT #1___ACCOUNT #2___ACCOUNT #3___ACCOUNT #4 __123123_______456789_______789123________987321 Any ideas? -- sharpie ------------------------------------------------------------------------ sharpie's Profile: http://www.excelforum.com/member.php...o&userid=27847 View this thread: http://www.excelforum.com/showthread...hreadid=473578 |
|
#2
|
|||
|
|||
|
Hi!
How big is this list? Biff "sharpie" wrote in message ... I need help. Is there aynone out there who can do some data tricks for me in Excel. I have a list of emails and associated account numbers. The problem is that one email may have 20+ account numbers associated with it, so I need to filter the spreadsheet to de-dupe the emails but keep all associated account numbers. Currently the sheet looks something like this: EMAIL_________ACCOUNT # ____123123 ____456789 ____789123 ____987321 But I need it to look like this: EMAIL_______ACCOUNT #1___ACCOUNT #2___ACCOUNT #3___ACCOUNT #4 __123123_______456789_______789123________987321 Any ideas? -- sharpie ------------------------------------------------------------------------ sharpie's Profile: http://www.excelforum.com/member.php...o&userid=27847 View this thread: http://www.excelforum.com/showthread...hreadid=473578 |
|
#3
|
|||
|
|||
|
about 45,000 including the duplicates -- sharpie ------------------------------------------------------------------------ sharpie's Profile: http://www.excelforum.com/member.php...o&userid=27847 View this thread: http://www.excelforum.com/showthread...hreadid=473578 |
|
#4
|
|||
|
|||
|
That's too big to do what I was thinking. It would take forever to
calculate. Biff "sharpie" wrote in message ... about 45,000 including the duplicates -- sharpie ------------------------------------------------------------------------ sharpie's Profile: http://www.excelforum.com/member.php...o&userid=27847 View this thread: http://www.excelforum.com/showthread...hreadid=473578 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Duplicates from a list | Excel Worksheet Functions | |||
| How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions | |||
| Transfer Items to a list with no duplicates | Excel Worksheet Functions | |||
| How do I find duplicates in a list | Excel Discussion (Misc queries) | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Linear Mode
