 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2006Grouping Similar items
Hi, I need some advice on a worksheet i have. Here is what it is. Example Name Email Area J.Doe j@hotmail.com WASH J.Doe j@hotmail.com NY M.Pesy M@yahoo.com VA J.Doe j@hotmail.com MX Each of the abov is in each row and column.I have like 800 ppl like that in the sheet with multipe names attached to diff areas. Now i want to have a macro that can group all those similar names and put it under one name like J.Doe and all the areas associated with it.Is this workable. I could do it manually,belive me i tried and its a lengthy process. Advice>?  Signaturecrosswire123 About 30 seconds to do that with a Pivot table. Assuming you have a header on each column, Select all your data and do data / PivotTable and Pivotchart report, then hit Next / Next / Finish. Drag Name into ROW fields and then drag Area BETWEEN the ROW field and the DATA field. Done. Another option for a nice table of data:- Drag Name into ROW fields and then drag Area into COLUMN field. Now also drag Area into DATA field. SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- > Hi, I need some advice on a worksheet i have. > Here is what it is. Example [quoted text clipped - 12 lines] > I could do it manually,belive me i tried and its a lengthy process. > Advice>? Thank you.It worked beautifully. im surprised they didn't teach us this at Univ lol thanks once again Signaturecrosswire123 You're very welcome. The Pivot table is probably the single most powerful feature that excel has (Yet can be so simple to use), and is certainly worth getting to grips with. Regards Ken.................. > Thank you.It worked beautifully. > im surprised they didn't teach us this at Univ lol > thanks once again |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.