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 need to have cell I8 be a drop-down list like it is already. From there I need cell I11 to show a drop-down list based off of the selection chosen in I8. This will have to come from a Table as the values in J11 and K11 will be a vlookup function of what is show in I11. For example if, I8 shows TYPE V, then I11 should have a drop down of numbers from 7 to 4. If they choose 6 for I11 then the value for J11 should return 4 and K11 should return 3 as seen in the tables set in the TAB "Choice Food Calculations" from cells A32:C51. If I8 was changed to TYPE I then J11 should return a 5 and K11 should return a 3 as seen from those tables
Solved by V. A. in 19 mins
I am trying to compare duplicates in two coloums - and I do the following: 1) I highlight column A 2) Choose conditional formatting and new rule: ‘Use a formula to determine which cells to format‘ 3) When I write this formula: =countif($B:$B, $A1), I am told that this is not a formula
Solved by F. B. in 21 mins
In Google Sheets, I have a validation dropdown that has a list of items. The cell also has a formula to set the column based on certain criteria (or let the user choose a different item from the list). My problem is that, whenever you hit the drop-down arrow, not only does the list display, but also the formula at the top of the list! I don't want the formula to show there. It's already in the formula bar. I don't want it showing in the drop down. Any suggestions?
Solved by Z. Y. in 26 mins
Cells C4 (product) and D4 (account) are changed manually. I need if one of the 2 is blank, SUM all the values. For example: if I choose a product sum all products of the accounts. This formula only changes when the two cells have information or both are blank =IF(OR($C$4="",$D$4=""),SUMIFS(H20:H459,$G$20:$G$459,$G$4),SUMIFS(H20:H459,$E$20:$E$459,$C$4,$D$20:$D$459,$D$4,$G$20:$G$459,$G$4))
Solved by O. J. in 25 mins
I have Excel 2010 is there a way to choose three solid colors rather than gradient? Is there a way to turn off the gradient?
Solved by A. C. in 23 mins
I need to create bar graphs that represent multiple variables, such as discipline by race, from survey data that is in text form. I would ideally like it to look like a bar graph were the X-axis is each discipline, with a cluster of bars above each that shows the number in that discipline by race. The text of the data is from multiple-choice questions, so the responses have consistency, but respondents were allowed to choose multiple answers and the way the data was provided, these are all entered in a single cell (for example, one cell might say "Educator" and another might say "Educator,Supervisor/Manager of Providers").
Solved by A. H. in 22 mins
Hi, just wondering if i can set a list in data validation but allow people to over write the cell if there is not an option in the list they wish to choose?
Solved by E. H. in 22 mins
I need an "IF" formula. If there is a $ amount in a certain range (say, B4:B34) count it as "1". Take the sum of whatever is in that range (say, 24 counts of "1") and divide it by whatever number I choose.
Solved by C. S. in 23 mins
If it was possible to introduce higher driver pricing during specific hours to increase supply and decrease demand, what weekly schedule of price multipliers would you choose? Visualise in a heatmap.
Solved by K. E. in 25 mins
I am creating a db for my videos. I created 3 colums and I want to write different tags in every cell but when I click on the filter option it gives me the options only to choose karate kick boxing judo as it is only one word. is there any way to write multiple words in the cell and be able to filter for each of those?
Solved by I. J. in 24 mins