G
Guest
From a table of information I would like to display a full row or rows of
data based on a set of lookup criteria, if a1:a20 has a value = to 20
+ or- 10% and the same row has a value of 50 + or - 10% b1:b20
The values will always change, therefore I would like the formula to look at
a cell where I can input the required value and automatically filter when
the value is changed
To help you understand the spreadsheet is a simple list of equipment model
numbers with capacities fan dimensions and noise data I would like to input 3
Selection criteria and be presented with each row that complies with in 10%
selection criteria and be presented with each row that complies with in 10%
Thanks for any help you can provide
data based on a set of lookup criteria, if a1:a20 has a value = to 20
+ or- 10% and the same row has a value of 50 + or - 10% b1:b20
The values will always change, therefore I would like the formula to look at
a cell where I can input the required value and automatically filter when
the value is changed
To help you understand the spreadsheet is a simple list of equipment model
numbers with capacities fan dimensions and noise data I would like to input 3
Selection criteria and be presented with each row that complies with in 10%
selection criteria and be presented with each row that complies with in 10%
Thanks for any help you can provide