Showing only rows where the wording is similar

Copper Contributor

Hi there,

 

My spreadsheet is attached.

 

I am trying to figure out how to only show rows where the wording in column B is used in column A. Would there be a function for this?

 

An example would be row 44. B44 is '1 Archway Mews' and A44 is '1 Archway Mews Freehold Limited'. This would be a row I need.

 

Any help would be greatly appreciated as I'm stumped!


Thank you.

 

4 Replies

@jshawyer 

 

try this formula

=IFERROR(SEARCH(B2,A2),0)

 

you can also check the fuzzy search add-in for Excel

https://www.microsoft.com/en-us/download/confirmation.aspx?id=15011

 

 

@jshawyer 

 

On your first sheet I added a column and in it used FIND to identify companies where your stated condition exists.

 

On sheet 2, I added a FILTER function (which requires the newest edition of Excel) that filters and shows only the companies identified in Column A of the first sheet.

 

If you don't have access to the FILTER function, you can still use the menu item Data.....Sort to accomplish the same on your sheet 1

Thank you both very much! Exactly what I needed. 

@jshawyer 

Those two responses illustrate the truth that there are, within Excel, many ways to resolve situations.