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

In a sheet that has workers name on the right side and types of items they have repaired on top, I need to make it so that, instead of having a different sheet for each day of the week, every week of the year, etc, I can make it so that, within the same sheet, I can choose which date to display and then fill in the information.
Solved by M. H. in 16 mins
I want to color the cells background based on a value of the cell beforeFor example: B3 cell background colored is based on the value on B2 cell if it less than or greater than I want to choose a color for that
Solved by F. F. in 16 mins
how do i choose what type of graph to use?
Solved by T. U. in 15 mins
I would like to make this production tracking chart to save data by selected month. As in when i choose a different month in the "Month" drop down list, the numbers correspond to the month selected.
Solved by G. Y. in 24 mins
I have two trucks Truck A rents for $325 and holds 75 panels Truck B rents for $450 and holds 150 panels I need a formula that will look at the quantity of panels we need and then choose the cheapest option of truck combinations. 75 panels would be Truck A 76 panels would be Truck B 151 panels would be 1 of each etc, all the way up to 10,000 panels
Solved by O. J. in 26 mins
I need a formula to capture the following scenario from a list of options: Options: 15 14 16 17 - Answer is 15 Explanation: out of the above numbers we chose the lowest 2 and from the lowest 2 (i.e. 15 and 14) then we choose the highest (i.e. 15) - Could you help me to generate a formula for this. Also ... option 2: 15 15 16 17 - Answer is 15 Explanation: we choose the lowest 2 (15 and 15) and in this case since the 2 numbers are the same we choose the same number (i.e 15) I appreciate your help to generate the formula.
Solved by K. L. in 16 mins
Hello, I have a workbook set up that my clients can choose options on the "customer sheet" and the value is added on the "proposal" sheet. Then that gets summed up and totaled at "proposal E1204" That is then showed on the customer sheet on D7. When a client makes a selection, the value changes. How can I show on cell F7 on the customer sheet what that change was?
Solved by M. H. in 14 mins
I am Chinthani from Sri Lanka..I am a student. This based on my assignment. Thanks lot you are maintaining this kind of valuable site... English is not my native language. So please apologize if there is a mistake. I think these explanations will clear for you. I have three question 1) Submitted sheet with this question have separate sheets. There are  QAD inspection  Stock report  Data entering sheet etc. • QAD inspection to be used as a Data entering sheet, as a separate Date Wise. • If someone need to entering the data, he needs to choose date from “Inspection done Date “column. • Due to all data's in one she
Solved by B. E. in 30 mins
I AM TRYING TO CREATE A FORMULA THAT WILL CHOOSE THE CORRECT NUMBER , IE IF y is between 1 - 6000 then X y BY 19% IF y is between 6001 - 11000 then X y by 20% and so on can such a formula be writtern
Solved by C. Q. in 29 mins
Create a button. this is often titled “command button” for PC’s and “button” for Macs. Input the following code in the Visual Basic Editor: Sub Button1_Click() Range(“A1”).Value = “Aloha” End Sub If you are having issues entering the Visual Basic Editor, right click the button, choose “Assign macro,” then press “New” to enter the code. Click on the button to see “Aloha” in cell A1. This is the assignment, I have to record myself doing this. I am on mac and am having trouble using the visual basic editor. I am not sure if I am putting in the code correctly becasue there is highlighted text with an arrow
Solved by X. F. in 27 mins