Howdy All,

I have a workbook that contains service data for units.

Column A = Model Name (alpha) 87 model names that repeat throughout the
column
Column B = Serial Number (numeric), unique number that repeats throughout
the column
Column C = Service Hours
Column D = Service Req Number

Model Name appears many times in column A
Serial Number appears many times in column b.

I want to determine how many of each Model Number I have with a unique
Serial Number.
But each Model Name and Serial Number can occur many times in their
respective columns if there have been multiple Service Requests.


Thanks,
Brian