Grouping Similar items
 

Hi, I need some advice on a worksheet i have.
Here is what it is. Example

Name Email Area
J.Doe WASH
J.Doe NY
M.Pesy VA
J.Doe 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?


--
crosswire123
------------------------------------------------------------------------
crosswire123's Profile: http://www.excelforum.com/member.php...o&userid=33051
View this thread: http://www.excelforum.com/showthread...hreadid=528665

Grouping Similar items
 

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------




"crosswire123"
wrote in message
news:crosswire123.25jsyo_1143832206.2725@excelforu m-nospam.com...

Hi, I need some advice on a worksheet i have.
Here is what it is. Example

Name Email Area
J.Doe WASH
J.Doe NY
M.Pesy VA
J.Doe 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?


--
crosswire123
------------------------------------------------------------------------
crosswire123's Profile:
http://www.excelforum.com/member.php...o&userid=33051
View this thread: http://www.excelforum.com/showthread...hreadid=528665

Grouping Similar items
 

Thank you.It worked beautifully.
im surprised they didn't teach us this at Univ lol
thanks once again


--
crosswire123
------------------------------------------------------------------------
crosswire123's Profile: http://www.excelforum.com/member.php...o&userid=33051
View this thread: http://www.excelforum.com/showthread...hreadid=528665

Grouping Similar items
 

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..................

"crosswire123"
wrote in message
news:crosswire123.25jutb_1143834602.9458@excelforu m-nospam.com...

Thank you.It worked beautifully.
im surprised they didn't teach us this at Univ lol
thanks once again


--
crosswire123
------------------------------------------------------------------------
crosswire123's Profile:
http://www.excelforum.com/member.php...o&userid=33051
View this thread: http://www.excelforum.com/showthread...hreadid=528665