Get instant live Excel expert help to learn how to use Small function in Excel

I have a column of 80 numbers of which I need a formula to get the averAGE OF THE SMALLEST SIX NUMBERS

I need a function that will give me the next smallest value in a row and display it in a summary sheet.

I WANT TO ADD THE SMALLEST NUMBERS TOGETHER FROM SEPERATE COLUMNS INTO ONE CELL

I am looking for formulas that will display the actual numbers based from smallest to largest from a column of numbers (for example, if A1=1, B1=4, C1=2, D1=1, and E1=3 (each of these values can actually be anything from empty to 7) I would like G1=1, G2=2,and G3=4. G1 is easy. use the formula "=if(sum(a1:e1)=0,"",min(a1,e1))" G3 is also as easy, using the formula "=if(sum(a1:e1)=0,"",max(a1,e1))" I can not figure out how to get G2 to show the number in the middle (or in the event of 4 different numbers, how to find and show the middle 2 numbers respectively)

Need to find all rows in a table for a particular date and for a particular employee, and then find the smallest time in an associated column.

I have a 24x5 table that I want to sort in a few ways. First, I want to sort by the data in the second column, which can be any of 0, 1, or 2. Then, I want to take the rows that have 0s in them and sort those by the data in column 3 from smallest to largest. It's all numeric, and the numbers in this table are based on numbers elsewhere in my spreadsheet. But every time I try to sort it, the formula I have set in the cell changes. See "Sheet 1", M1 to Q25.

Hello I used a template "project tracker". I changed it purpose from projects to offers. I put in offers partial price and total price. I added data validation dropdown list for 3 partial price items, for choosing the price. I added conditional formating to the total price and now I want to sort it by total price...smallest to biggest value. Ex. Offer 1|Part1-60000$|Part2-15000$(or 10000$)|Part3-15000$||Total-90000$; Offer 2|Part1-50000$|Part2-25000$||Total-75000$ After sort, choosen values stay the same but data validation show values for particular cell and cond. formating for total price has the color bar bigger for 75000 than for 90000

Hey I couldn't find out the smallest +ve number by the formula =MIN(IF(I7:I13>0,I7:I13))

To arrange the figure in the 2018 table, from largest to smallest (based on the week chosen from the drop down list)

To arrange the figure in 2018 column, from largest to smallest