Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-24-2017, 06:18 AM
Barbiro Barbiro is offline Help with Formula Mac OS X Help with Formula Office 2011 for Mac
Novice
Help with Formula
 
Join Date: Jun 2017
Posts: 3
Barbiro is on a distinguished road
Question Help with Formula

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Formula 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
Help with Formula 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft