Here's what I have:

A spreadsheet sent to me with a list of filter part numbers, with each
vehicle having it's own row and each type of filter (air, oil, etc) having
it's own column. I would like to create from this data a sorted list of each
different filter part number, along with a count of how many times that part
number is on the sheet. Part numbers contain both numeric and alpha
characters in some cases. It seems like something not so hard to do, but I've
been bashing my head for some time!