Use this revised one instead, in D2:
=IF(COUNTA(B2:C2)=0,"",IF(SUMPRODUCT((B$2:B$200=B2 )*(C$2:C$200=C2))1,"dupe",""))
Copy down. Adapt the fixed ranges to suit the extent of your actual data:
B$2:B$200, C$2:C$200
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Quimera" wrote in message
news:kmt%j.407$i74.332@edtnps91...
My apologies - it does work for the row AFTER a duplicate but I also need
to show a duplicate BEFORE a row. i.e. when there are 3 or more duplicate
rows they should all show "Dupe".
Thanks