Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-21-2017, 06:01 AM
jsisley jsisley is offline Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell? Windows 7 64bit Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell? Office 2010 64bit
Novice
Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell?
 
Join Date: Jul 2017
Posts: 1
jsisley is on a distinguished road
Default Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell?

I have a spreadsheet that contains 5257 rows of data. One of the column names in this spreadsheet is Asset Name.



This column contains data as follows:

32413
36756
33615
LOM32413
LPA36756
LAL33615

In my application of this data, LOM32413 is a duplicate of the 32413 entry.

Is there a way I can use a formula to have Excel find this type of "duplicate" entries when only PART of the cell's data is a duplicate of the entirety of another cell?

Any help or suggestions are appreciated. Thanks!

JoAnn
Reply With Quote
  #2  
Old 07-21-2017, 09:20 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell? Windows 7 64bit Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Something like =MATCH("*"&a1&"*",$a$1:a2,0) in B1 ( pull down as needed)
This will return there n indicating a partial match of the value contained in the nth cell
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can Excel find Duplicate entries when only part of the cell's data is a duplicate of another cell? Duplicate Calendar Entries from Office to Personal mail dylansmith Outlook 1 04-26-2017 04:34 AM
Duplicate entries yourforester Outlook 1 11-15-2014 10:44 PM
Calendar - Duplicate Entries castow Outlook 0 02-05-2014 02:53 PM
Removing duplicate index entries Bengt Word 5 03-01-2013 02:01 AM
How Can I Flag Duplicate Date Entries? tatihulot Excel 5 11-16-2012 12:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:23 AM.


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