G.

Kk

hexzelle:
Good day, would keep it short and simple.

I need help with a bunch of data sets that have similarities, but would need an automation programme or soft ware to help with the issue.


I'm not sure if that pix is clear
so i have attached an excel file

if one opens that file in excel, there are about 25 number sets there , if one observes carefully one would find out that each set contains a number between(30-32=100%) ORANGE, i.e. all 25 sets have either 30, 31, or 32
while 24 sets contains between (20-22=95%) ONLY COLORED LITE BLUE.
and also 24 sets contain between(21-23=95%)DARK BLUE.
all three are a range of 3 numbers.

but also all 25 contain(20-23=100%) which is a range of 4 numbers i.e. 20, 21,22,23

my question now is if there is a function on excel or another software, where i can enter different sets like this, and choose either a 2 NO range, 3 NO range or 4 NO range and then it would give me the range of numbers that is present in all the sets i.e. (100%) or a percentage basis of the ranges automatically.

All help will be gladly appreciated.

I can use python programming to solve your problem. Contact me via my signature

Semtu:


I can use python programming to solve your problem. Contact me via my signature

G