First thank you for looking at this and sorry for the long post and formula,
if it's not clear please let me know.

I'm trying to figure out how to re-write the below array formula:

=COUNT(1/FREQUENCY(IF(LEFT('[Spares Quotes List V22
26Apr2007.xls]All'!$A$2:$A$5003,4)=RIGHT($A41,4),IF('[Spares Quotes List V22
26Apr2007.xls]All'!$F$2:$F$5003<"",IF('[Spares Quotes List V22
26Apr2007.xls]All'!$P$2:$P$5003<"",MATCH('[Spares Quotes List V22
26Apr2007.xls]All'!$P$2:$P$5003,'[Spares Quotes List V22
26Apr2007.xls]All'!$P$2:$P$5003,0)))),ROW('[Spares Quotes List V22
26Apr2007.xls]All'!$P$2:$P$5003)-ROW('[Spares Quotes List V22
26Apr2007.xls]All'!$P$2)+1))

What this formula does is compares the id number in column A on both
worksheets and then looks at column F to make sure it's not blank then counts
all the unique supplier names in column P that aren't blank. The problem I
have just run into is say the supplier has 3 parts and only prices 2 of them,
the formula counts the supplier as complete when they aren't. Can this
formula be written a different way to still only count the unique supplier
names but have the criteria be to count them only if all parts are quoted?

Thank you in advance for your help and sorry for the long post.

Joe