Get instant live Excel expert help to learn how to use Choose 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

How would I find the percentage of how many games are won? You are going to play a game where you bet a dollar and get to flip a coin ten times. If you get four heads in a row, you win. If you make the tenth flip without getting four heads in a row, you lose. Run this game ten thousand times. Approximately what is the probability that you will win? (choose the proper range)
Solved by B. U. in 14 mins
Hello, I need a VBA code that creates a copy of active worksheet and saves it at a user defined path. We can use a prompt to choose the folder for saving the file
Solved by V. Y. in 11 mins
choose match issue. Want to make formula to bring currency depending on country
Solved by F. B. in 16 mins
needing a formula to choose rando m years from 1960 to present day..but not to pick a number within 10 years of the previous number
Solved by C. B. in 19 mins
I have a macro that allows me to choose the size of a table for inputting data, but now everytime I try to add data into a cell the workbook refreshes and takes me to the end of the document. The following is my code: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Select Case Range("C15") Case "Select" Application.Rows("1:1000").Select Application.Selection.EntireRow.Hidden = False Rows("18:318").Select Selection.EntireRow.Hidden = True Case "5x3" Application.Rows("1:1000").Select Application.Selection.EntireRow.Hidden = False Rows("22:35").Select Selection.EntireRow.Hidden = True Rows("42:55").Select Selection.EntireRow.Hidden = True Rows("62:318").Select Selection.EntireRow.Hidden = True Case "10x3" Application.Rows("1:1000").Select Application.Selection.EntireRow.Hidden = False Rows("22:35").Select Selection.EntireRow.Hidden = True Rows("42:55").Select Selection.EntireRow.Hidden = True Rows("62:75").Select Selection.EntireRow.Hidden = True Rows("82:95").Select Selection.EntireRow.Hidden = True Rows("102:115").Select Selection.EntireRow.Hidden = True Rows("119:318").Select Selection.EntireRow.Hidden = True Case "15x3" Application.Rows("1:1000").Select Application.Selection.EntireRow.Hidden = False Rows("22:35").Select Selection.EntireRow.Hidden = True Rows("42:55").Select Selection.EntireRow.Hidden = True Rows("62:75").Select Selection.EntireRow.Hidden = True Rows("82:95").Select Selection.EntireRow.Hidden = True Rows("102:115").Select Selection.EntireRow.Hidden = True Rows("122:135").Select Selection.EntireRow.Hidden = True Rows("142:155").Select Selection.EntireRow.Hidden = True Rows("162:318").Select Selection.EntireRow.Hidden = True Case "20x3" Application.Rows("1:1000").Select Application.Selection.EntireRow.Hidden = False Rows("22:35").Select Selection.EntireRow.Hidden = True Rows("42:55").Select Selection.EntireRow.Hidden = True Rows("62:75").Select Selection.EntireRow.Hidden = True Rows("82:95").Select Selection.EntireRow.Hidden = True Rows("102:115").Select Selection.EntireRow.Hidden = True Rows("122:135").Select Selection.EntireRow.Hidden = True Rows("142:155").Select Selection.EntireRow.Hidden = True Rows("162:175").Select Selection.EntireRow.Hidden = True Rows("182:195").Select Selection.EntireRow.Hidden = True Rows("202:215").Select Selection.EntireRow.Hidden = True Rows("219:318").Select Selection.EntireRow.Hidden = True Case "30x3" Application.Rows("1:1000").Select Application.Selection.EntireRow.Hidden = False Rows("22:35").Select Selection.EntireRow.Hidden = True Rows("42:55").Select Selection.EntireRow.Hidden = True Rows("62:75").Select Selection.EntireRow.Hidden = True Rows("82:95").Select Selection.EntireRow.Hidden = True Rows("102:115").Select Selection.EntireRow.Hidden = True Rows("122:135").Select Selection.EntireRow.Hidden = True Rows("142:155").Select Selection.EntireRow.Hidden = True Rows("162:175").Select Selection.EntireRow.Hidden = True Rows("182:195").Select Selection.EntireRow.Hidden = True Rows("202:215").Select Selection.EntireRow.Hidden = True Rows("222:235").Select Selection.EntireRow.Hidden = True Rows("242:255").Select Selection.EntireRow.Hidden = True Rows("262:275").Select Selection.EntireRow.Hidden = True Rows("282:295").Select Selection.EntireRow.Hidden = True Rows("302:315").Select Selection.EntireRow.Hidden = True Case "10x10" Application.Rows("1:1000").Select Application.Selection.EntireRow.Hidden = False Rows("119:318").Select Selection.EntireRow.Hidden = True End Select End Sub
Solved by V. D. in 25 mins
I have a macro that allows me to choose the size of a table for inputting data, but now every time I try to add data into a cell the workbook refreshes and takes me to the end of the document. I need help adding a line of code that will allow not to lose my place in the file
Solved by I. J. in 22 mins
I'm looking to create a sheet drop-downs change depending on what was chosen in the previous cell. For example, if you look at the sheet i've attached, if I choose a certain item, i'm then able to choose correlating colors/sizes for that specific product since the sizing and colors are variable by product type.
Solved by S. E. in 22 mins
I would like to know how to create a option button for an excel table to choose different data .
Solved by Z. H. in 30 mins
Was wondering if there is a way to create a formula that would randomly choose between 2 words (Winner and Loser), but Winner would show up 30% of the time and Loser would show up 70% of the time?
Solved by M. E. in 24 mins
Hi, I am currently working on a formula but it keeps on displaying the error warning. I am currently working on an eBay upload file where, if you upload it onto eBay, the HTML displays pictures in accordance with the chosen genre. For example, if I choose "Bike", then, the HTML displays bike photos extracted from our photo server in the body content of a product on eBay. The exchange file already had 2 genres, and I am now adding two new 2 genres. Thus, I am adding the 2 genres in my formula that I am working on, but it only seems to be displaying the error alert. I will send you the formula.
Solved by X. W. in 25 mins