Grouping Same Data in column

[martialtiger]

Hi Guys,

Using: Excel 2000
Issue: Is there a way to create groupings based on same values down
particular column.

Example: I have phone numbers listed down column L. But some of th
numbers appear more than once. Can I automatically create groups base
on the same phone numbers so it would be easier on the eye to follow.

Hope this makes sense.

TIA

Jonas :cool

 

[Debra Dalgleish]

You could sort the list by the phone numbers, and use conditional
formatting to highlight the rows that contain a duplicate phone number:

Select a cell in the list
Choose Data>Sort
Sort by phone number, click OK

Select all the cells in the list (e.g. A2:M1000)
Choose Format>Conditional Formatting
From the first dropdown, choose 'Formula Is'
In the formula box, type: =$L2=$L1
This formula refers to the active row, and the row above it
Click the Format button
Select a different font colour or font style for the duplicate rows
Click OK, click OK

 

[martialtiger]

Thanks for the response Debra, but I am really looking for a way to jus
group the rows according to column L. I appreciate the help!

;

 

[Debra Dalgleish]

Sort on column L
Choose Data>Subtotal
From the 'At each change in' dropdown, choose Phone Number
For 'Use function', choose Count
For 'Add subtotal to', choose Phone Number
Click OK

 

[martialtiger]

Thanks Debra,

This solves the problem and even adds extra that can be useful!