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

So I am trying to create a Vacancy calendar that i can use to compile automatically and distribute the available vacancy week (max 3 employee in vacancy during the same week) Here my idea: B5,H5,O5 etc ... are the Week # the employee must choose. for B6,H6,O6 etc... i used =COUNTIF and take the data from a table where each employee made their choice On the table, the choice 1 is the one that shall be used if there are 3 or less employee that chose it, If there is more than 3 people who chose it, the second choice will instead be used and the 1 choice should be eliminated. I am struggling to find a solution on how the code can determine the priority of employee, cause the older employee will alway have priority over the newer employee.
Solved by E. J. in 30 mins
I have a three sets of data, courses, positions and operating units. I would like to be able to choose a course and see which position and operating unit this course is for, is this possible in excel?
Solved by T. W. in 21 mins
Getting a error when making a change in a formula within the "MASTER_data" tab, choose cell "L3". You can make any change to this formula then you'll get an error "cannot find....filename.xlsx, copy from:". I can't find where any of my formula's are referencing this file name. So, need help resolving.
Solved by E. A. in 17 mins
I have an excel file with multiple formulas for discounts, now I need an option to choose which discount do I apply, but cant figure out the formula for that
Solved by M. D. in 22 mins
Morning; is it possible to put the attached data into a form (probably a pivot table) so that i can choose a date (i.e. 4.9.17) and it then generate a list of regions (line 2 on Company Matrix) that have this date on them, and the corresponding campaign code (column B) that needs to be sent to each region? Ideally i want each column filterable too.
Solved by C. S. in 13 mins
hello I want to make a time sheet in excel for the company employees its attached I don't want to create a separate file for each employee then multiple sheets in each file for each month I saw some files online where you create a drop down list for employees then whenever you choose an employee you get his own data in the same sheet is this related to conditional vlookup and can only be applied when the changes between employees data are only in formatting? is it related to VLOOKUP? I also want to apply the same concept to years/months so I can stay in the same sheet while viewing the details for all employees for whatever year or month I want thanks
Solved by T. S. in 29 mins
I would like a vba pop message box that if yes is chosen then the workbook opens as normal but if you choose no then the workbook opens as read only
Solved by C. H. in 18 mins
Is there a way to create a formula that will automatically choose the next item in a drop down list?
Solved by S. L. in 28 mins
Hi, I'd like to know the following: How to add one more line to the 'Pick up' drop down menus located in B12 and B26.. specifically a '-' if they do not wish to choose a pick up option. How to have the service charges on C8 only show up when values are inputted in D5 and/or E5 and the service charges on C22 only show up when values are inputted in D19 and/or E19. How to lock all the other values other than what is highlighted so that the document cannot be altered other than by me. Please and Thank you!
Solved by F. H. in 15 mins
Formula identify the stage/aging of project milestone - possibly choose function
Solved by M. U. in 21 mins