Remove Differing Min Max Values Across Multiple Columns
I’ve tried various loops and row filters, including rule based, and just cannot get this to work.
I have a series of columns, each with five values in rows, and wish to remove the MIN and MAX value rows within each column. I thought Group Loop would do it (as each column has separate MIN MAX values), and this works with Math Formula to derive the MIN MAX, but I can’t make the Rule Base Row Filter to remove the MIN MAX rows within the loop.
There’s a series of columns
Then I want to match up to the primary column the MIN and MAX derived values and remove those rows–I’m assuming within a loop, as every primary column has completely different MIN MAX values.
Attached is the data in excel format prior to the MIN MAX calculations.
As always, your advice is greatly appreciated.