Compare Two Columns In Two Worksheets & Identify Duplicates

I

isadoko

Active Member
Joined
Jan 10, 2005
Messages
322
Office Version
  1. 365
Platform
  1. Windows
I am using the following solution:

=IF(ISNUMBER(FIND("GRB2",B9,1))=TRUE,"FLS2",IF(ISNUMBER(FIND("GRB",B9,1))=TRUE,"FLS",IF(ISNUMBER(FIND("#billing",B9,1))=TRUE,"#billing","None")))

This is looking at a cell where I have concatenated the value(s) of 10 columns (V-AE). From that grouping I want to identify and pull out the terms above. However, it is only pulling one of the terms; I need all matched terms, eg, GRB2, GBR, #payment ...

Net, I need a way to pull all the matched terms. Thanks for the help.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
You must log in or register to reply here.

Similar threads

M
  • Question Question
Comparing two columns with comma separated string values (match) and output: matching string/text
Replies
6
Views
440
Fluff
Fluff
A
  • Solved
Comparing two excel files for matching / mismatching rows (long text strings - match() wont work
Replies
4
Views
962
ahaye
A
E
  • Solved
Filter and Textjoin formula if two columns match a text value in a cell - excel 365 in a Mac
Replies
7
Views
342
Fluff
Fluff
J
  • Solved
Match Data and Input Value
2
Replies
11
Views
2K
Fluff
Fluff
O
  • Question Question
sum or subtract for the same cell based on match column between two sheets
2
Replies
13
Views
837
Omran Y
O

Forum statistics

Threads
1,223,903
Messages
6,175,287
Members
452,631
Latest member
a_potato

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top