LinkBack URL
About LinkBacks
Hi,
My problem: I need to highlight duplicates. A duplicate is a row with e.g. the first two cells the same as the first two cells of another row.
Thanks for your help!
Hi,
My problem: I need to highlight duplicates. A duplicate is a row with e.g. the first two cells the same as the first two cells of another row.
Thanks for your help!
Hi
As you are in Excel 2003, use SUMPRODUCT, for this..
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
i think this works
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks