I have a komma seperated text string in a cell: 25659,56582,56585,65855,58558.
I want to check if all of these seperated numbers exist in a specifiek column with numbers. For example B:B. How do i do this?
I have a komma seperated text string in a cell: 25659,56582,56585,65855,58558.
I want to check if all of these seperated numbers exist in a specifiek column with numbers. For example B:B. How do i do this?
If this is a one-off exercise, you could just use text to columns, comma delimited and then use COUNTIF or VLOOKUP to check the individual values.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks