No change, still no error messages. I changed this to 100 rows for the time
being.
I placed this in each row in the column's next to J + extered unique +
duplicate rows.
=IF(SUMPRODUCT(--(B$2:B$100&C$2:C$100&F$2:F$100&G$2:G$100&J$2:J$100 =B2&C2&F2&G2&J2))= 1,TRUE,FALSE)
The result of this on each row shows 'false'. I copied + pasted one person's
info to assure I'm not doing typos. also tried it like this + got 'false'
=IF(SUMPRODUCT(--(B$2:B$100&C$2:C$100&F$2:F$100&G$2:G$100&J$2:J$100 =B2&C2&F2&G2&J2)=1),TRUE,FALSE)
Further I changed the filters as below + got the results listed -
=IF(SUMPRODUCT(--(B$2:B$100&C$2:C$100&F$2:F$100&G$2:G$100&J$2:J$100 =B2&C2&F2&G2&J2)=1),TRUE,FALSE) all false
=IF(SUMPRODUCT(--(B$2:B$100&C$2:C$100&F$2:F$100&G$2:G$100&J$2:J$100 =B2&C2&F2&G2&J2)) 0,TRUE,FALSE) all true
=IF(SUMPRODUCT(--(B$2:B$100&C$2:C$100&F$2:F$100&G$2:G$100&J$2:J$100 =B2&C2&F2&G2&J2)0),TRUE,FALSE) all false
=IF(SUMPRODUCT(--(B$2:B$100&C$2:C$100&F$2:F$100&G$2:G$100&J$2:J$100 =B2&C2&F2&G2&J2))1,TRUE,FALSE) all true
=IF(SUMPRODUCT(--(B$2:B$100&C$2:C$100&F$2:F$100&G$2:G$100&J$2:J$100 =B2&C2&F2&G2&J2)1),TRUE,FALSE) all false
=IF(SUMPRODUCT(--(B$2:B$100&C$2:C$100&F$2:F$100&G$2:G$100&J$2:J$100 =B2&C2&F2&G2&J2))=1,TRUE,FALSE) all false
=IF(SUMPRODUCT(--(B$2:B$100&C$2:C$100&F$2:F$100&G$2:G$100&J$2:J$100 =B2&C2&F2&G2&J2)=1),TRUE,FALSE) all false
This goes along with my always getting error message or never getting them.
How is it yours works + mine doesn't??? I'm missing something!!!
If you can't see anything, can you send me your test excel sheet? I'll look
at that and compare things - . Thanks.

Stresssssssssssssed