D
Demosthenes
Hello,
I have a question. I have two sets of data, one of which is contained in the
other. The problem is, the big set has additional data that I want to isolate
for the shorter data set. For example:
a 123 123
b 234 789
c 345 234
a 456 890
b 567
c 678
a 789
b 890
where column A is the additional data, column B is the large set, and C is
the small set. I want to pull out the instances where the data in a single
cell in column C matches any single cell in column B. My result is:
123 a
789 a
234 b
890 b
Can anyone give me any ideas? I'm really stuck here. Thanks!
I have a question. I have two sets of data, one of which is contained in the
other. The problem is, the big set has additional data that I want to isolate
for the shorter data set. For example:
a 123 123
b 234 789
c 345 234
a 456 890
b 567
c 678
a 789
b 890
where column A is the additional data, column B is the large set, and C is
the small set. I want to pull out the instances where the data in a single
cell in column C matches any single cell in column B. My result is:
123 a
789 a
234 b
890 b
Can anyone give me any ideas? I'm really stuck here. Thanks!