Can an advanced filter do this...??

B

BVHis

Being the Excel "newbie" that I am, I'm hoping someone can shed som
light on Advanced Filters and if it can do what I HOPE it can do.

I've got a BOM generated from data from AutoCAD. The BOM contain
information such as 'room name', 'room number', '# of telephones', '
of PCs', etc...

What I would like to do is be able to create a new sheet (that's th
easy part), then extract and SUM the information based on the roo
number. For example: If I have 3 entries for room 101 where entry
has: 1 telephone & 0 PCs; Entry 2 has: 1 telephone & 2 PCs; Entry 3 ha
3 telephones and 1 PC.

I'd like to be able to combine that information to read: Room 101,
telephones & 3 PCs.

It SEEMS that the Advanced Filter can do this, but I just don't hav
NEARLY enough experience with Excel to even know where to begin.

Any help will be greatly appreciated!

Thanks in advance!

Matt
 
D

Dianne Butterworth

Matt W,

It sounds like you need a pivot table. Select a cell somewhere in your
data area then invoke the Pivot Table wizard.

In the Row area, drag Room Number
In the Data area, drag # of PCs, # of telephones, etc.

You should end up with a nice table summarised by Room Number.

Post back if you need clarifcation.
 
Top