I have a table to pick numbers according to their attributes. What I normally do is to use filtering, but it is not very efficient and comfortable to use. I've attached the excel file with the table having the numbers and their attributes. and beside the table you can see the filter boxes. What I would like to have is to use these selection boxes to filter numbers and list them down below in the filtered numbers part. In the selection boxes, I'd like to put numbers between 0 and 6.
So the options for the selection boxes can be 0-6, 1-5,2-4,3-3, 4-2,5-1,6-0. For example, if I enter 2 in Odd box and 4 in Even box, the numbers should be selected according to these proportions. Ofcourse the idea is to use as many of the filters to narrow down the numbers according to the filtering criteria.
I am not if this can be done with excel, but I'm open to any help I can get. Thanks in advance. I hope I made it clear.
Worksheet: https://1drv.ms/x/s!AsEuzEWSPBGqdfsYdjdievuo1Po
So the options for the selection boxes can be 0-6, 1-5,2-4,3-3, 4-2,5-1,6-0. For example, if I enter 2 in Odd box and 4 in Even box, the numbers should be selected according to these proportions. Ofcourse the idea is to use as many of the filters to narrow down the numbers according to the filtering criteria.
I am not if this can be done with excel, but I'm open to any help I can get. Thanks in advance. I hope I made it clear.
Worksheet: https://1drv.ms/x/s!AsEuzEWSPBGqdfsYdjdievuo1Po