I am very new to coding in excel and I've run into a problem. I have created a workbook to help me log and run data on my internship hours. I have to have them organized by semester and also by standard (there are 6), however some activities include more than one standard, so I have a multi select drop down list for the standards column. I have two other sheets that have SUMIFS formulas that refer back to the standards column in the first sheet. The condition is that if a certain number exists in the cell, it should add the total hours in a separate column. As long as I select more than one standard, it finds the number and the formula works. However, if I only select one standard, it does not recognize that it's there, and it is left out of the data on the other sheet. How do I get the cell in the standards column, which is currently coded to allow the multi select dropdown list in a single cell, to recognize if I only choose one option? I included some screen shots.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Single select recognition in a multi select dropdown list
- Thread starter smmould
- Start date
