| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting&Sorting multiple serial numbers per machine type
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compile numbers from multiple worksheets | Excel Worksheet Functions | |||
| HOW CAN I TYPE MULTIPLE LINES IN A CELL | Setting up and Configuration of Excel | |||
| Can you add multiple numbers in the same cell%3f | Excel Worksheet Functions | |||
| Re What is the formula for adding multiple numbers in a cell | Excel Discussion (Misc queries) | |||
| Counting multiple numbers in one cell | Excel Worksheet Functions | |||
Threaded Mode
