Simplify formula

Any help would be appreciated.

This seems like a simple enough concept to me. I want to compare two values, A8 & C8 to all preceeding sets of values in the given column. If they match any other set, I'd like one value and if they do not I'd like another. In other words, I'd like to identify the first instance of sets within identified columns.

I can make it work but it seems dirty and instead of 8 test lines I would be looking to extend it down the entire column. Can you help me clean it up?

=IF(OR(AND(A8=A1,C8=C1),AND(A8=A2,C8=C2),AND(A8=A3,C8=C3),AND(A8=A4,C8=C4),AND(A8=A5,C8=C5,AND(A8=A6,C8=C6),AND(A8=A7,C8=C7))),0,1)

Thanks for your help.

In C1 (or any column you wish), enter =SUMPRODUCT((A$1:A1=A1) * (B$1:B1=B1) ) > 1 and copy down. It returns True if the same A/B combination has appeared in a prior row.

Please read the Forum Rules about thread titles before starting your next thread.