Thanks, that looks like what I need but it gives me the same result of always
giving the "duplicate row" message even when I enter unique information. I
tried it with 0 instead of =1 but there were no changes. Any other ideas???

"daddylonglegs" wrote:


Select column J and use this formula in data validation

=SUMPRODUCT(--(B$1:B$100&C$1:C$100&F$1:F$100&G$1:G$100&J$1:J$100 =B1&C1&F1&G1&J1))=1

extend the range (beyond row 100) if necessary, you can't use whole
column references


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