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