Cwillson
New Member
- Joined
- Oct 1, 2015
- Messages
- 36
- Office Version
- 2019
- Platform
- Windows
Hey peeps,
I have a spreadsheet with a range in column (A) containing comma separated values in each cell.
I also have another range in column (B), consisting of cells with just a single value in each.
I'm looking for a formula which will confirm which of the comma separated values in column A can be found in column B. There may of course be more than one, so ideally I'd like a comma separated cell with the matching values.
If this last bit is super complex using formula (I can't run VB on work laptop - sigh) then it would be fine to simply return a "Y" if any of the comma separated values in column A can be found in column B!
Many thanks in advance!
C
I have a spreadsheet with a range in column (A) containing comma separated values in each cell.
I also have another range in column (B), consisting of cells with just a single value in each.
I'm looking for a formula which will confirm which of the comma separated values in column A can be found in column B. There may of course be more than one, so ideally I'd like a comma separated cell with the matching values.
If this last bit is super complex using formula (I can't run VB on work laptop - sigh) then it would be fine to simply return a "Y" if any of the comma separated values in column A can be found in column B!
Many thanks in advance!
C