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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 11:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com