Posted to microsoft.public.excel.newusers
|
|
Compare adjacent fields in adjacent rows
Hi Max,
Yes!!! Works beautifully. Many thanks indeed.
Joan
"Max" wrote in message
...
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
|