choice

  1. S

    How to get the best of 3 choices according to the highest number?

    Can i check how do i get the final choices from this table to the second table? Employee Name Attendance Percentage Choice1 Choice2 Choice3 Alan 75.09333333 Project 1 Project 3 Project 4 John 73.37 Project 1 Project 4 Project 2 Alan 73.15 Project 3 Project 5 Project 6 Chris...
  2. C

    Choice allocation with preference and priorities

    Hi all, I am looking for a way to do something similar to others on this forum around allocating choices to a number of work experience placements. I have anywhere between 60-100 students each year who rank five placement preferences from over 50 placements (who have between 1 and 3 spaces)...
  3. L

    can excel help pick out top choice?

    let say i have a group of kids that get to pick out their three favorite toys. Because the number of toy available is limited, only the kids with he highest grade get their #1 choice 1. the rest get their 2nd or 3rd choice depend on their grade and availability. <tbody> kids grade # 1...
  4. M

    How do I Make a 3 bar chart in excel?

    Hi, I am making a bar chart in excel and I currently have it as a 2 bar chart, but I could really use a 3rd bar. I do not see an choice for a 3 bar..is this do-able in excel??
  5. R

    Excel Selector

    Hi, I chanced upon this product selector. Values will depend on the choice selected, may I know how to do it? Thanks, https://www.dropbox.com/s/5jd8kus6f3p21hh/Product-Selector.xlsx?dl=0
  6. I

    Query

    Hello, I have the following question: I have created 6 queries with a lot of data. The data is from SAP. (Methode: data - from file - from workbook). The excelsheet has become very slow. I use the data to create a financial overview of all scientific reports. I use one worksheet for a report...
  7. tzallas

    Run the same Macro on multiple workbooks

    With some great help from the forum community here, I have managed to use a macro that runs through a dropdown list and exports a sheet to a pdf in a user determined location Huge thanks to Yongle See this thrread for details...
  8. D

    Rankings on First Come, First Serve

    I have this information in which applicants for a conference are ranking their preferences for example (red, yellow, orange). What formula can I write so that I give the person their first choice, but then when that area gets filled up with more than 1/3 of the people at that conference it shows...
  9. 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...
  10. K

    VBA CODE sorting any range of data

    Hi Guys, can you help me writing a VBA code line. Need to execute a macro, where gives me the option to sort any range of data to my choice , after i select it ,instead pressing alt+h+v,etc, etc.. Maybe this code, could ask me from witch column i want to sort the range, or I it run it for a...
  11. E

    Multiple IF selection formula

    Trying to come up with an IF formula that gets to the "Final Choice" selection in the last column (E). Choice #1 will always have priority over all other choices. Thanks. <colgroup><col span="4"><col></colgroup><tbody> <tbody> A B C D E 1 <tbody> Choice #1 </tbody> <tbody>...
  12. F

    Conditional Format query

    Is it possible to highlight cells based on another cell. That is a bit of an oversimplification. My table looks something like this: <tbody> Choice 1 Choice 2 Choice 3 Choice 4 Choice 5 Choice 6 Option W Option X Option Y Option Z History Spanish Media RS PE Art History Spanish Art RS...
  13. J

    Automatically update of secondary cell entry in cascading dropdown menu

    Hello, I have a list of price in 2 languages : French (FR) en English (ENG). Here is a model : <tbody> Please select a language Dropdown list 1 (choice : 'FR' or 'ENG') </tbody> <tbody> Object 1 50 Eur Object 2 100 Eur Dropdown list 2 (choice : 'maison' or 'avion' in FR / 'house' or...
  14. Y

    EXCEL VBA MACRO TO email SHEET AS PDF ATTACHMENT

    I want to do as the title states. Print a certain range as pdf and send as attachment with a choice of a body. Can someone help me ? Thanks YM
  15. J

    What formula should I use?

    Hi, Can advise which formula should I use if I want to seek the answer as below criteria? If I need to purchase pen/paper: 1. Company A will be always the priority, 2. Company B will be the 2nd choice if Company A did not sell this item, 3. Company C will be the last choice if both Company...
  16. M

    selected vLookup cells with multiple choice options

    On a page 1 of my worksheet I have 6 cells that have vLookup and I want to have some of them with multiple item choice, but not all of them. The code for multichoice applies to all of the vLookup cells by page. Is there a way to have only selected vLookup cells have multiple choice option while...
  17. Nelson78

    VBA and dropdown list: a case of "only choice"

    Hello everybody. I've set a dropdown list as follows: https://imgur.com/a/ntDkIK9 Dim MyListB(2) As String MyListB(0) = "YES" MyListB(1) = "NO" Dim lrut2 As Long lrut2 = Cells(Rows.Count, "A").End(xlUp).Row With Range("B2:B" & lrut2).Validation .Delete .Add Type:=xlValidateList...
  18. A

    Unable to figure out why this VBA code is not executing as directed.

    Private Sub Inputtest() Dim intResponse As Integer intResponse = MsgBox("Do you want to do work?", vbYesNo) If intResponse = 1 Then MsgBox ("Good Choice") Else MsgBox ("Wrong Choice. Try Again") End If End Sub The code doesn't run as i expect. When i answer yes i get wrong...
  19. S

    Quiz by VBA

    Hi, I want to organize a quiz with multiple choice questions (a, b, c & d) which I send t the participants by e-mail. I would like to register how they score per question but also how long the participants have to think for each question. In other words, from seeing the question until they...
  20. J

    Formula help needed

    Hi, i have an excel file (attached). It has a list of names and then periods (1-10). Each name has listed 2 activities they'd like to participate in. I'd like each person to get their first choice 60% of the 10 periods and second choice 40%. I also need to make sure that each period and activity...

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