![]() |
|
#1
|
|||
|
|||
|
I was asked to analyze a very LONG list for duplicates. I tried using "Conditional Formatting" but the problem with that is that it also highlights "triplicates, etc." and NOT ONLY "duplicates" which is what I want. What I need is this: If the B2 column contains 2 identical "duplicates" (usually one below the others as in "2846 and 3445"), then I want on the C Column for it to say "True". I want the formula to skip triplicates, etc... exclusively pointing out sets of two. Thanks for any help you guys can give me on this... totally appreciated.
2846 2846 2930 2930 2930 2930 3445 3445 2778 2778 2778 2778 2778 2778 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
|
innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
WHEN formula
|
agent007 | Excel | 5 | 02-06-2014 09:20 PM |
| Formula Help | clo312 | Excel | 11 | 01-11-2014 02:54 AM |
| Formula Help | OTPM | Excel | 5 | 02-21-2013 08:03 AM |