choices

  1. Y

    Lottery Enrollment by choice/preference

    Greetings all, I am looking for a way to do something similar as (Student Choice), and I have tried to manipulate the macro but it's a bit more complex and beyond my brain power lol. We have at a sports school for kids ranging from age 3 through adults and given the popularity would like to...
  2. D

    Responsive list / pivot - No VBA

    Hi Guys, Forgive me the thread title, but I had no idea how to call it. I'm having a table, where I have to choose Yes/No. If I choose Yes, I want this choice to be displayed in another table. It can be partially done with a pivot, but I need to press refresh each time I make any changes in my...
  3. A

    Method for maintaining listbox possible values

    Hi, I'm usually an Excel person and not so much an Access person so please forgive my stupid question: I plan to build a database which in various forms rolling up into various tables I want to control selection choices a user can make. Some of these list might be 3 options long, some might be...
  4. J

    use excel to input data into a program

    We have a program we use for some work, its a exe file that runs in a dos window. It starts with a menu of 5 choices, and I would like to use excel to populate the menu choices, and also other operations. Is this something excel can do, or is there a better way? It would involve opening files...
  5. J

    Allocate choices to respondents

    Hi, I've got a dataset of respondents in the format of: Respondent 1 - Choice 1 - Choice 2 - Choice 3 etc. Respondent 2 - Choice 1 - Choice 2 - Choice 3 etc. [for 100s of respondents] I am trying to allocate choices so that each respondent gets as many of their choices as possible The issue...
  6. H

    Cell to allow only 1 - 1000 in numeric order

    I want excel to limit A3:A1003 user to only input numbers 1-1000 for their choices form highest to lowest and if they go out of order to alert next value is the missing number ex: if users input 1,2,3,4,5 and if users accidentally tries to input 7 as next value for excel to prompt message "...
  7. K

    Userform - Match and return criteria (2 criteria conditions)

    hello. I am working on a userform in which I would like to have 2 criteria options; the 1st being a number (1-100) and the second being a choice from a drop down list. When user enters the number and selects the drop down - I would like 4 different list boxes to generate information. Example...
  8. P

    Count Unique Values

    Hello, I have a spreadsheet where column A represents a person (1-242) and column B represent a choice that person made (1-5). Each person in column A gets to make 12 choices (i.e. there are 12*242=2904 rows). I would like a formula that counts the number of unique choices each person makes...
  9. S

    Tricky (for me) VBA copy and paste.

    I have two data validation lists. The second is dependent on the first. So let's go with the old fruit and vegetable tables. First list, my choices are Fruit or Vegetable. The second list is dependent on the first. Let's say if you select Fruit, your choices are Apple, Orange, and Pear in the...
  10. D

    Several Vlookups from drop downs needing to add results in each cell

    So my spreadsheet has 7 drop down boxes with 10 choices, they all have the same choices which are Meal Choices, the ingredients are listed left to right in a table on a different sheet. This is to generate a complete ingredient list in a table of ingredients (already created) for all 7 drop...
  11. M

    Call a picture from an If statement

    I am working on a spreadsheet and want to call a picture based on an if statement. There are 6 main choices with 8 sub choices. For example: You wouls choose a car model with an X, and then choose a service also with an X. Them you would click a button, "Submit Request". the program would...
  12. G

    Cell data & custom format

    Hello guys & Gals, I have excel 2013 and I am trying to do something but cant seem to. In column A I want a leading / before any data I enter in the cell. So for example I want "/time" or "/545" (just examples.) I tried custom format and format tried was ?"/"? and tried 0"/"0 and several...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top