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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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
816
Fluff
Fluff
A
  • Solved
Comparing two excel files for matching / mismatching rows (long text strings - match() wont work
Replies
4
Views
1K
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
384
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
863
Omran Y
O

Forum statistics

Threads
1,225,739
Messages
6,186,743
Members
453,370
Latest member
juliewar

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