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