1 Reply Latest reply on Oct 30, 2013 7:41 AM by Matt Lutton

    Simple? I have four numbers, in 4 columns, and I want to remove the highs and lows.

    michael.wu

      There are lots of functions to help me do with if the data was in a single column like [Sales], but the data is spread across 4 columns.

       

      [test 1], [test 2], [test 3], [test 4] I'm trying to throw out the highs and lows of that and then average the remaining two.