choice

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...

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)...

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...

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??

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

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...

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...

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...

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...

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...

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>...

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...

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...

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

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...

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...

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...

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...

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...

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...