Hello,

I’ve tried a ton of different functions and it seems that I simply have to make a huge nested IF function for this but I will see if any of you smart excel folk have any answers first.

I have a category in my list where there are 4 columns and 4 rows (however each row is independent so its fine to consider it as one)

The column headers are properties of our equipment (equipment type, serial number, thickness etc.)

Im looking to have each cell in each column show all available option when all cells in the row are blank and for each cell that has data input into it, the filters start adding up.

e.g. if i add an option for equipment type then the serial numbers and thicknesses filter down to include that. and if i add a thickness then the serial numbers would include both filters.

I have made it work when i input data from left to right on the row but ideally i would like to make it also work if people start adding information in a random order to start filtering their options for the remaining blank cells in the row based on whichever cells have data in them.

Is there an easy IF OR solution for this or will i just have to make a nested if function for the entire list of options for what cells are blank or filled in?

Thanks for your help 

​Hello, I’ve tried a ton of different functions and it seems that I simply have to make a huge nested IF function for this but I will see if any of you smart excel folk have any answers first. I have a category in my list where there are 4 columns and 4 rows (however each row is independent so its fine to consider it as one) The column headers are properties of our equipment (equipment type, serial number, thickness etc.) Im looking to have each cell in each column show all available option when all cells in the row are blank and for each cell that has data input into it, the filters start adding up. e.g. if i add an option for equipment type then the serial numbers and thicknesses filter down to include that. and if i add a thickness then the serial numbers would include both filters. I have made it work when i input data from left to right on the row but ideally i would like to make it also work if people start adding information in a random order to start filtering their options for the remaining blank cells in the row based on whichever cells have data in them. Is there an easy IF OR solution for this or will i just have to make a nested if function for the entire list of options for what cells are blank or filled in? Thanks for your help   Read More

​