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

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I have 246 people on one spreadsheet and i have to type in their 401k on another spreadsheet that has 687 people on the other. How can i just find the people on the bigger spreadsheet coming from the smaller spreadsheet so i can put in the 401k. i have to do this manually at work and it takes me hours and if i make 1 small mistake it takes me even longer!
Solved by K. W. in 30 mins
SMALL THING. I WANT SOMEONE TO DO WHAT ANOTHER REP DID FOR ME ON ONE FILE TO ANOTHER. I CANT ASEEM TO GET IT RIGHT. THIS IS THE FILE HE/SHE JUST FIXED.
Solved by A. C. in 25 mins
I have a data set with big numbers and small numbers comparing each other and the small numbers do not show on the scale because it is too big
Solved by E. E. in 28 mins
When I try to open an excel file that has been saved, instead of opening I get a small green and white box in the upper left of my PC and I can't get it to do anything, like open.
Solved by C. W. in 27 mins
I need help with this question: A casino manager wants to introduce a fun game (that gives the customers an advantage). The Game: 1. A random colour machine displays either GREEN or RED. 2. Customer picks a colour and wins if their colour is displayed 3. A round involves 10 games. Of which GREEN is displayed 6 times on average (to give the customer an advantage) 4. Pay out is the stake x 0.7 (so if you select green and bet \$1, your total return is \$1.70 if green appears. But you lose \$1 if red appears) (the customer still has a small advantage) QUESTION: What is the optimal betting strategy, to ensure that the customer wins \$50 after every round (10 games) if the customer started with \$100. Please help me with this question
Solved by D. Y. in 25 mins
I need an excel formula that can solve this: I want to introduce a fun game (that gives the customers an advantage). The Game: 1. A random colour machine displays either GREEN or RED. 2. Customer picks a colour and wins if their colour is displayed 3. A round involves 10 games. Of which GREEN is displayed 6 times on average (to give the customer an advantage) 4. Pay out is the stake x 0.7 (so if you select green and bet \$1, your total return is \$1.70 if green appears. But you lose \$1 if red appears) (the customer still has a small advantage) QUESTION: What is the optimal betting strategy, to ensure that the customer wins \$50 after every round (10 games) if the customer started with \$100.
Solved by I. J. in 16 mins
Continuation of my last question... INDEX(Sheet2!A:A,small(IF("N"=INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19),ROW(INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19))-ROW(INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19),1,1)+1),1))
Solved by M. J. in 30 mins
If you are not the person who wrote this INDEX(Sheet2!A:A,small(IF("N"=INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19),ROW(INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19))-ROW(INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19),1,1)+1),1)) then dont think you can fix it. route it to him who wrote it.
Solved by F. F. in 28 mins
You have made this but now I want to insert new row in sheet two but it won't get added in overview sheet. The formula is =IFERROR(INDEX(Sheet2!A:A,SMALL(IF(INDIRECT("sheet2!"&INDEX(Formula!B:B,MATCH(MATCH(Overview!\$A\$2,Sheet2!\$1:\$1,0)+3,Formula!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Formula!B:B,MATCH(MATCH(Overview!\$A\$2,Sheet2!\$1:\$1,0)+3,Formula!A:A,0))&19)="Y",ROW(Sheet2!E3:E20)-ROW(INDEX(Sheet2!E3:E20,1,1))+1),ROW()-1)+2),"")
Solved by E. E. in 27 mins
Hypothesis testing that returns of a company are greater than returns to the market using Data Analysis: t-test: 2 small assuming unequal variances what mean difference should I define?
Solved by B. S. in 16 mins