Am using Windows 365, Excel.
Have searched quite a bit, but can’t find the solution I’m looking for.
Am running a Filter function to pull out certain fields from a file.
Will keep this simple to start.
Is D4 (Filter function output) +-10% of D6 (static number lets say)
*Just looking for a way to show only those lines that are +-10% of another cell and ‘spill’ those lines.
Basically, the output of my current Filter function will check for this as its last test.
*
Have played around with several options, but not getting it yet.
Current function string I am using does not include this yet. Am trying to get it working from a basic start first. Then apply it to my function to keep it easier.
Here is the syntax of my current function. Not including this new request: =FILTER(‘Shipping Related Charges’!A5:ED576,(‘Shipping Related Charges’!D5:D576=B3)(‘Shipping Related Charges’!E5:E576=D3)(‘Shipping Related Charges’!G5:G576=F3),”Not Found”)
Here is shortened version of what I’m working with.
Goal is when you fill in the info for cells in row 517, final output should show all shipments having a weight match with +-10% of weight entered in cell:i517 (hope my chart is showing ok)
My test results area is on lines 528, with the following function in it: =FILTER(‘Shipping Related Charges’!A520:J525,(‘Shipping Related Charges’!D520:D525=C517)(‘Shipping Related Charges’!E520:E525=E517)(‘Shipping Related Charges’!G520:G525=G517),”Not Found”)
Not sure how to add into this function what I’m trying to get for end result yet. That’s why it is not there. The function as is works great, except for the +-10% weight addition needed.
Have played with ‘IF’ and ‘ABS’, but haven’t figured it out still.
Have tried the following adjustment to my test function and seems to be off still. Tried a couple variations and still don’t have it:
=FILTER(‘Shipping Related Charges’!A520:J525,(‘Shipping Related Charges’!D520:D525=C517)(‘Shipping Related Charges’!E520:E525=E517)(‘Shipping Related Charges’!G520:G525=G517),”Not Found”),((H520>=(I517-0.1I517))(H520<=(I517+0.1*I517))))
Here are the results from it:
Thank you in advance,
