I need help with an average function. I have 8 colums of data. column A cotains the name of the hardware, B-H contain values for the week. I need to average column b-h where it doesn't include the maximum and minimum value for each row.
Some videos you may like
Whats the difference between CONCAT and CONCATENATE?
i Need Help With An Average Function. I Have 8 Colums Of Data. Column A Cotains The Name Of The Hardware, B-h Contain Values For The Week. I Need To Average Column B-h Where It Doesn't Include The Maximum And Minimum Value For Each Row.