hi there, i need your help again!
i have a lot of ranges with names (Bond ISINs, contain also numbers) and one range to which i have to compare these other ranges. I have to detect all deviations to the "main" range (called MF005) and vice versa. The sizes of ranges are different, sometimes the main range MF005 can contain more and sometimes less names, than other ranges.
Example:
MF005
aaa
aab
aac
aad
abb
abc
Range x
aaa
aac
aad
axx
abc
First difference: MF005 has aab, abb more than Range x
Second difference: Range x has axx more than MF005
I have to detect these two kinds of differences. What would you suggest?