Another Excel question

tcofran

Expert Member
Joined
Jun 17, 2009
Messages
2,631
Good morning MyBB

Is it possible to find duplicate (not exact) like conditional formatting can do?

If have a big spreadsheet and I want to find entries that are almost similar.. For example, one will be Langebaan and the other will be be Erf 196 Langebaan. It must go through the spreadsheet and list all the things that are alike. I don't want to add a rule it must just find the same spelling in a sheet

Hope this makes sense.
 

LaraC

Honorary Master
Joined
Mar 11, 2014
Messages
40,496
If the duplicate values are in one column you can use Filters. It has many options you can chose from to extract the values you need. :)
 
Top