Insert a new column in B and add a formula of

=SUMPRODUCT((C12:EK12<"")/COUNTIF(C12:EK12,C12:EK12&""))=COUNTA(C12:EK12)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Daniel- Sydney" wrote in message
...
Hi

I have Excel 2002.

I have a spreadsheet with a number of ingredients in the first column and
the next 130 columns have formulations for various products made on the
ingredients in the first column, these formulation all add to 100.

Is there a way i can automatically check for any duplicate formulations?

Thanks

Daniel