Aug 12 2020 04:12 AM
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.
Aug 12 2020 04:26 AM
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
Aug 12 2020 04:35 AM
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
Aug 12 2020 06:01 AM
Thank you both very much! Exactly what I needed.
Aug 12 2020 06:07 AM
Those two responses illustrate the truth that there are, within Excel, many ways to resolve situations.