# 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 need help with this question: A casino manager wants to introduce a Xmas 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 K. S. in 25 mins
I need help with this question: A casino manager wants to introduce a Xmas 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. Just give me an idea about how can I approach this particular problem.
Solved by E. J. in 23 mins
A casino manager wants to introduce a Xmas 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 C. J. in 20 mins
Hi, I need to create a formula. I have columns which have certain attributes which are listed as follows: 1 Blue Big Hot 2 Red Small Cold I need a formula which lists these values as follows: 1 Blue 1 Big 1 Hot
Solved by M. H. in 28 mins
I need help with this question: A casino manager wants to introduce a Xmas 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 I. E. in 19 mins
I need an excel formula that can solve this: 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.
Solved by F. F. in 18 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. B. in 29 mins
Sorting inside a large pivot table Specifically, I want to group small amounts and put this group at the bottom of a table that is otherwise sorted Largest to Smallest (i.e. I am consolidating "small" amounts in a group called "Other") I want to repeat this inside a large set of data for smaller discrete
Solved by S. H. in 26 mins
Howdy! I have just received a boatload of data and I was wondering if there was a more efficient way of doing what I am trying to achieve. The data is bus data: I am tasked with figuring out how long the bus is out of the garage (so that we can calculate how much to pay the drivers). I have the time that the bus arrives at the first school and the time that the bus arrives at the last school it serves before going back to the garage. I also have how long the bus spent loading students and how long the bus took to get from the garage to the school; and how long it took the bus to get to the garage from the school. With these bits of data, I want to be able to easily calculate the total time spent on the road for each bus. I have an example spreadsheet that I have included that contains all this data and a small key illustrating what I am trying to do (outlined above). There are A LOT of records in it, which is why I would like a more efficient way to do this as opposed to just pounding them out one by one. Is there a way to do this? Or am I just going to have to grit my teeth and grind these out? Thank you!
Solved by I. B. in 21 mins
Attached is an excel workbook that mirrors "registration reports" created for each event. There is a set of Macros based on the "registration list" tab that is used to populate the three corresponding tabs: Confirmed, Pending, Cancelled/Declined. There are 5 small "bugs" in the Macro page that prohibits the Macros from running properly. To open the Macro page press Alt + F11. I need help reading through the macro page, understand the pattern, to fix all 5 errors. I aim to have a completed sheet with the tabs populated.
Solved by I. B. in 21 mins