I have a table that scores the number of frames in a movie that fits a certain combination, which is identified by a series of numbers (101010, 10101 for example (71 combinations in total)). From this -in the third column- I can calculate the fraction of frames that falls into a certain category.
What i want to do is to find the fractions that DO NOT fall into a set of combinations. Or delete the ones the fall into a particular set.
Basically I want to ignore a bunch of numbers from the first column.
Or find a way to highlight where this set of combinations are.
Is there a formula for this? My guess is that VLOOKUP would work but i have basic knowledge of it.
Hope I managed to explain myself.
Thanks in advance.
101011 34 0.165853659
101010 33 0.16097561
10101 29 0.141463415
110101 27 0.131707317
111110 19 0.092682927
11101 14 0.068292683
11111 12 0.058536585
111011 9 0.043902439
111111 7 0.034146341