Thread: Search
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Malik Malik is offline
external usenet poster
 
Posts: 47
Default Search

I have a set of digits in one cell separated by a comma and a bigger set or
master set of digits in the other cell. Is there a formula where I can
segregate the unmatching digits of the two cells onto the third cell

E.g,.

A1: 121, 211, 244
B1: 121, 211, 1314, 566, 667
What I want as result:
C1: 1314, 566, 667 (ideally B1 - A1)

Thanks