![]() |
#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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
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 |