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

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

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

Help would be appreciated - Thx! :)


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

--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=552062

It does depend a bit what you want to do with the results. But my quick
preference would be to use acces and either create a table LINKED to
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 grouping
on. Set columns 1 & 2 to group and column 3 to count and execute it.

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=552062

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
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=552062

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
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=552062

No other ideas? :(


--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=552062

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.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=552062