I hope someone can help me with this! I am trying to create a formula that will select the last 10 numbers in a row then drop the highest and the lowest number and return an average for the remaining 8 numbers. Row 1 on the worksheet is a list of dates and row 2 is a number for that date. Not all cells in row 2 have data in them some are blank and should not count in when retrieving the last 10.

Any help with this would be great!