keyword count and unique entries

[jetskiguy02]

I'm trying to find a formula that will count the number of times a part number is matched, but only for each unique occurrence of that part number. For example, Column A has 100 part numbers. Some are unique. Column B has either "Matched", "No Matches", or a quantity associated with each part number. I think some combination of "Vlookup" and "Countif", but I can't think of how to tie them together.
Basically the plain english version of the formula would be like "countif(From A1 to A100, if the value is unique and B(whichever row is currently being evaluated) equals "Matched")).

[Jdevil]

Try this:

=SUM(--(FREQUENCY(IF(($B$1:$B$24="Matched"),COUNTIF($A$1:$A$24,"<"&$A$1:$A$24),""),COUNTIF($A$1:$A$24,"<"&$A$1:$A$24))>0))

Change 24 for the appropriate #

it's an array function so confirm formula with CTRL SHIFT ENTER

[jetskiguy02]

That worked perfectly! Thanks!

[Tony Valko]

In other words...

Count the unique part numbers that correspond to "matched".

What do the part numbers look like? Are they actually numbers? Do any start with leading zeros?