Counting&Sorting multiple serial numbers per machine type

[Dark_Templar]

I have a sheet with
col A: holding serial number, per
col B: machine type.

One machine type has multiple serial numbers,which can be repeatin
too.

I would like to list all serial number per machine type and count ho
many times one serial number per machine type occurres.

As its pretty hard to explain, so I added an examplesheet - it's quit
obvious in there.

Help would be appreciated - Thx! :

+-------------------------------------------------------------------
|Filename: example.zip
|Download: http://www.excelforum.com/attachment.php?postid=4891
+-------------------------------------------------------------------

 

[tony h]

It does depend a bit what you want to do with the results. But my quic
preference would be to use acces and either create a table LINKED t
your spreadsheet or import the Excel table into access.

Then using the query designer in access put machine type in one column
serial number into a second column and also into a third. Put groupin
on. Set columns 1 & 2 to group and column 3 to count and execute it.

regard

 

[Dark_Templar]

Thanks for the quick response.

This should be running on multiple computers (maybe without access)
or to what r u refering by "it depends"

 

[Dark_Templar]

Thanks for the quick response.

This should be running on multiple computers (maybe without access)
or to what r u refering by "it depends"

 

[Dark_Templar]

No other ideas?

 

[tony h]

Well done,

I always forget about pivot tables as they don't really feature in the
sort of work I do. Slightly surprised no one else mentioned them.