choice

Looking for assistance on the following: I have a basic drop-down list which has a choice of Yes or No. I am trying to write a formula that will check which was selected in the drop-down. If the choice was Yes, then x, else y Is this possible? Thank you!! -BB

Hi so I've created a macro that starts a timer and alerts me when the countown is complete. I'm creating a multiple choice question sheet and have 5 multiple choice questions timed. Less than 2 minutes each. I'm struggling to find a code that will stop the timer when they've answered. THanks.

Hi guys, I want to create a 2-item drop-down such that when you select each item it will populate the following 11 columns with pre-set values related to that item. Here's the sheet as it stands, which we've been populating manually by copying and pasting... I want to make the "TX...

hi I have a table of data with 6 columns columns B, D and F are the choice of subject columns for info only these list the subject names. In columns C E and G i want the user to be able to enter a Tick to select a subject from each column but only one so once a tick is entered into one cell...

Issue: I have a spreadsheet that I am trying to implement data validation lists with, but a bit beyond the standard. Below is the desired outcome: Select a cell in Column A. A drop down menu of a few items shows up (Choice A, B, C, and D). The choice you select is shown as text in the cell...

Hey All, using VBA/Macro is it possible to write to a .vbs (in text) file in a folder of choice. I have a spreadsheet at the moment, which builds blocks of text, using the & then I can change a few cells, the big block of text changes. I then manually open a .vbs file, and copy and paste into...

Hi, So, I have a large dataset with survey responses. Among them are multiple choice responses: I'd like to add them to a pivot table with chart, displaying them like this: Unfortunately, I can't find a way to do this. The closest I get is this: Obviously, that isn't the way to go as I...

I'm trying to come up with a formula that awards a schedule to employees. The employees are ordered by seniority. There are multiple openings per periods. The employees bid for the period they will work based on seniority and list them by their 1st through 5th choice. I found a solution...

Can anyone help with a formula or code that would automatically place individuals into their 1st, 2nd, or 3rd choice of program based on the following: The individual with the highest score determines the priority of placement There are a maximum number of placements for each program Placement...

Hi, I have a Google Doc with one multiple choice question. The rest of the questions are identifying information. We need to convert the single row responses into multiple rows. So each "Club Listing" should have a separate row, but the other cell info should be repeated for each. I have been...

I have a spreadsheet that is not in a usable format and need help rearranging it. It is currently formatted like the table below but with over 300 Kids and 20 clubs. This format has a lot of empty cells and its not easy to filter. <tbody> Name Club1 Club2 Club3 Club4 Club5 Kid1 Choice 1...

Is it possible to match the item if for example I type in 'an' and the suggestion will show the choice "plan"?

....something like this: =INDIRECT(SUBSTITUTE(E14&S14," ","")) plus the second choice, in this case "TBA" so maybe =OR(INDIRECT(SUBSTITUTE(E14&S14," ","")),TBA)

Hello everyone, I have an excel table (see the link at the end) and I would like to automate the incrementation of column C, I tried this function but there is still a malfunction: = SI ($ B5 = "success", REPT ("0", 4-NBCAR (NB.SI.ENS ($ B $ 5: $ B5, $ B5, $ A $ 5: $ A5, $ A5) .SI.ENS ($ B...

Hello all, I have a userform for data entry purposes of gathering a student's name and selecting an elective class based on preference (1st choice, 2nd choice, 3rd choice). In my userform, I created 3 columns for each of the choices. All 3 columns contain the same list of classes. I decided to...

Our office is voting on names for our conference rooms. My task is to declare the winners. People are asked to rate their top five choices from a list. Below is a sample of my data. Currently, the survey platform is telling me Siuslaw is the highest ranking choice--because it's using a weighted...

Hi, I've reviewed previous forum posts and attempted to figure out how to do this. No luck. I'm looking for a formula(s) that can extract the a. choice, the b. choice, the c. choice, and the d. choice (see example below). It does not need to be an all encompassing formula (if that's easier for...