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

I have created a simple macro and saved it, but when I select VIEW MACRO, I cannot see or choose the previously saved Macro which I used to be able to do easily........frustrating........and help appreciated.
Solved by I. Y. in 14 mins
I need a Data Validation Cell to create a sort of array of data from another Sheet. Meaning that if i Choose ''Option A'' in A Data validation cell a column combined of 28 other cells will be filled with data specified in a different sheet.
Solved by V. E. in 28 mins
I need help on making a formula to sort values in multiple columns, where if i choose one value in one column i don't want it to exclude the others. Example. Two colums next to eachother. A2 says basketball, B2 says basketball. A3 says Soccer, B3 says basketball. So when i sort the colums i want all lines With basketball in them to show up. If i try it now, the line With Soccer and basketball wont show up. Hope this explanation helps.
Solved by G. J. in 24 mins
I am trying to create a meal menu. I want to have multiple meal options that a person can choose from a drop down. Once that meal has been chosen, I want the ingredients to automatically fill into a shopping list. I would like to be able to adjust the number of people and have the amount of ingredients needed change for that number. How do I go about doing this or is it even possible?
Solved by C. W. in 22 mins
I want to create a menu where you can choose one of the meals from a drop down and have the ingredients from the meal automatically fill into a shopping list. Right now I have it set up so that you can choose how many people you have and the ingredients for the individual meals changes. Is it possible to link the option from a drop down and have it autofill a list?
Solved by D. A. in 20 mins
I have understood that correlation means how closely a certain data set fits a straight line. This would mean that a parabola for example would have a very low R^2. But is doesn't! If you choose different trendlines, trying to find the function that best fits the data, it seems the R^2 indeed approaches 1 the better the points fits the chosen function, and that it doesn't measure linearity at all. Can you please explain this to me?
Solved by I. C. in 23 mins
I have Windows 10 and Excel 2013. I am looking for a way to insert a drop-down calendar into a specific cell. All of the on-line suggestions so far talk about how to get a "pop-up" calendar, but I want to be able to click on a cell, get a drop down arrow, have the calendar pop up at that point, choose the date, and then have the date populate in the cell while at the same time the calendar goes away...
Solved by G. J. in 24 mins
Good day I need some help with a formula. Need to check a statement with an if statement if true return "" if false choose from a drop down menu
Solved by Z. Y. in 27 mins
I have a list of numbers in column A. In column B I am putting either a 1 or a 0 next to the numbers in column a that I want to choose. 1 meaning choose and 0 meaning dont choose. In column C I want the Chosen column A numbers to file down in order
Solved by A. Q. in 28 mins
I've made a table with assessment results for a class. I'd like to organise the list according to scores but when I choose 'sort ascending' it only sorts the scores. I need to link to names in column A with the scores in column B and then sort. How do I do that?
Solved by K. J. in 26 mins