Hi daddylonglegs,

Here's what I copied into the data validation -
=SUMPRODUCT(--(B$2:B$500&C$2:C$500&F$2:F$500&G$2:G$500&J$2:J$500 =B2&C2&F2&G2&J2))=1

I have a header on line 1. I get no error messages. Other ways I tried doing
this, I got error messages for everything. I highlighted column J + went to
data validation and only have it for that column. I just want to get it
working on one column, and if it's needed on the others, it will just be a
copy + paste. We're doing something different, probably something small. Is
there anything else you're doing?





"daddylonglegs" wrote:


Hi stressed,

It certainly worked for me yesterday and today when I tested again, you
should only get an error message if all 5 columns are the same for one
row, are you using exactly the formula I posted?

Also you need to apply that formula at row 1, if your applying from row
2 as per your example then alter the refs accordingly

daddy


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=501528