Selecting Answer From Multiple Cell

Dec 27, 2013

So I am creating a board game in excel. I currently have a draw card feature to draw random cards. I also have section above where you can fill in the answer to the question and another 2 sections that flip to correct or incorrect. Those formulas work as =IF(AND(Sheet1!J6="When resubmitting the claim to another insurance should you be voiding an adjustment to the S code if one is posted?",Sheet1!I2="Yes"),"That is Correct!"," "). I have another for if Sheet1!i2="no" then it flips to that is incorrect. I want an OR formula that will be like if multiple cells have any text in them it will display them but only one cell at a time. So essentially a way for multiple questions to be able to be drawn and you can answer those questions and be told if they are correct or not.

View 14 Replies


ADVERTISEMENT

Fill Answer In Multiple Cells From Value In One Cell?

Jun 18, 2013

I need an economical way to fill values in 12 cells.

I have a list of 50 cities in column A. For each city I need find and fill certain demographical values in columns, L2 through W50, consistent by looking up data in another sheet. Both sheets share the same column names.

I have tried =VLOOKUP(A2,'CitiesDemo'!$A$1:$W$51,11,FALSE) and it works well enough but I would like to drag across and down to avoid manually editing references.

View 3 Replies View Related

Selecting The Same Cell Across Multiple Sheets?

Feb 10, 2014

I'm after a bit of programming which selects the same cell on the next sheet that I have already selected.

So, If I'm on Sheet1 and I have G5 selected, when I change Sheets to Sheet3 for example, I want it to select G5 on Sheet3.

View 9 Replies View Related

Selecting Multiple Items From A List In One Cell.

Feb 10, 2010

Is it possible to restrict the values of cells in a particular column to entries defined in a list BUT to allow each cell in that column to display multiple items from the list (seperated by a comma for example). I've attached an example of what I would like to do -

In Sheet "2010 Data" I want to be able to select multiple values in column F....(the values are defined within the list named "Platforms" on the worksheet called "Lookups"

View 4 Replies View Related

Running A Macro To Copy Multiple Cells From A Row By Selecting A Cell

Feb 21, 2009

I want to be able to select a cell, for example A10, this would then run a macro that would copy and paste several cells of information along that row and paste it on another worksheet. However, if i then choose a15, a3, a79 in turn (using the control key), it would run the macro using those rows in turn.

i'm looking forward to hearing if and particuliar how this could be achieved.

View 13 Replies View Related

Subtracting From Multiple Cells To Get Specific Answer

Mar 11, 2011

I had a question considering a workbook that I am working on for overtime, a different one than I posted before. On my workbook, I have vacation leave, sick leave, and overtime to figure in. I want to be able to have a choice to choose which you would like to keep at the end of the week. Such as if you were to work 8 on Mon, 8 hours on Tues, 10 hours on Wed, and then take vacation leave on Thur, for 8 hours, and then work 6 hours on friday, I need a way to choose whether to be paid for the overtime and vacation time, or to subtract two hours from my overtime and add it to my regular time, i.e. 40 hours, or subtract two hours from my leave time and add it to my regular time. I know this sounds complicated, it is at least to me.

View 3 Replies View Related

Formula That Will Check Multiple Criteria Before Returning Answer?

May 14, 2014

Attached worksheet which is an sales incentive plan. I need cell B69 to represent the amount in b68 unless neither b30 or b99 are > 0. In other words if even 1 of the cells b30 or b99 come back positive, you get the amount in b68. If it comes back 0 in both cells b30 and b99, then they get 0.

View 4 Replies View Related

VLOOKUP Multiple Values Then Give Answer Based On Condition?

Feb 6, 2014

I have been struggling with this formula for ages and have finally given up. What I would like to do is to do a lookup on the concatenated values of Province, Department and Initiative No, which has mutiple values in the status of milestone column, and then give the answer based on a condition.

The condition for this example should be, that if the returned status / or statuses of the initiative is all 1, then the value should be 1, if it's all 2, then the value should be 2, and so on.....but if the values returned from the status of the initiative is a combination of 1,2 or 3, then it should give me the answer 2. If 4 is part of the comination of values returned, then the value should be 4.

Zero - 0 should be excluded from the formula as it is part of planned values and not actual.

View 5 Replies View Related

Excel 2003 :: Cross Reference Multiple Fields For Answer?

Aug 16, 2013

I have a sheet (sheet 1) of employee information for multiple buildings as follows:

Employee Name, Building, Pay Grade, Full Time Equivalent (of full time hours worked)

Anne, Centre A, Anne, Grade 2, 1.0
Bob, Centre E, Bob, Grade 3, 0.50
Carl, Centre H, Carl, Grade 2, 0.60
Dan, Centre B, Dan, Grade 1, 1.0
Emma, Centre A, Emma, Grade 3, 1.0
Fash, Centre A, Fash, Grade 2, 0.40
Gemma, Centre C, Gemma, Grade 2, 1.0
Hanna, Centre B, Hanna, Grade 1, 1.0
etc, etc, etc

From another sheet (sheet 2), I wish to populate the total of "Full Time Equililents" at each grade in each centre, eg:

CENTRE, GRADE 1, GRADE 2, GRADE 3
Centre A, 0 1.4 1.0
Centre B, 2.0 0 0
etc,etc,etc

I'm using Excel 2003 if that makes a difference

View 2 Replies View Related

Copy Correct Multiple Choice Answer Into Field Based On Number Identifier

Mar 23, 2014

I have a set of 4 multiple choice answers B,C,D,E column "F" lists a # 1-4 which lets you know which column letter (b,c,d,e) the correct answer is in. I want to set up a formula that will copy the contents of the correct answer (based on that # identifier) and copy it into column "A" which is currently blank.

View 7 Replies View Related

Copy Correct Multiple Choice Answer Into Blank Field Based On Corresponding Number Identifier

Mar 23, 2014

Here's an example of what i want to do

A_________ B Frank Sinatra C Sammy Davis D Dean Martin E Joey Bishop F 3

I want to put "D"'s value 'Dean Martin' in column A - i know it belongs in A because the "3" in column F indicates its the 3rd answer listed i.e Dean Martin. This format would be the same where there are 4 possible answers on the column to the right dictates which answer is correct.

View 2 Replies View Related

Return Answer Based On Cell Value

Aug 29, 2009

im looking to return an answer in cell c28. in b28 it will say "best goalkeeper"
in c28 i need a formula to look in range d2:d6 then return the highest answer and correspond that to whats in b2: b6. so we could say

(b2)shilton(d2) 33
(b3)corrigan (d3) 55
(b4)parkes (d4) 66
(b5)schmeichel (d5) 100
(b6)cudicini (d6) 14

in c28 it will return the answer schmeichel because he is the highest
and in d28 it would return the points he has.

View 2 Replies View Related

Can IF Function Result In Its Answer In A Different Cell?

Jan 15, 2010

Can this Formula work? Where if c2<e5 then its value is a number. The formula below is what i tried but it didnt work

=IF((C2<E5);"c5=value=f5")

View 2 Replies View Related

Get Picture To Pop Up When Certain Answer Is Selected In Cell

Mar 20, 2014

How I can get a picture to pop up when a certain answer is selected in a certain cell, or when a certain answer is keyed in to a cell. Another portion to this question is that we know how to get a message to pop up in a dialog box when a certain piece of information is typed in to a box, but we don't know how to get graphics into those dialog boxes.

View 3 Replies View Related

Answer For Comparing Cell Should Be True - Format Same

Feb 25, 2014

Here is the qtn if two cells A1 and A2 has "ab 1" and "ab 2" the answers for comparing cells should be true as both cells has first 2 letters as alphabets then space followed by numeric..format of cells is same.

View 2 Replies View Related

Hiding Answer To Formula If One Cell Is Empty

Nov 5, 2009

Is there a way to have the answer to a formula display nothing if one of the cells have nothing. Example cell A3= A1*A2 ... it will naturally show 0.00 but even if both A1 and A2 are completely blank. Is it possible for A3 to show nothing if A1 or A2 or both contain nothing. I still want it to show 0.00 but only if that’s what is in the other cells.

View 5 Replies View Related

If Certain Answer In Cell Then Find / Show All Other Instances

Nov 15, 2013

Why than going line by line on a document that has 60k rows!

I have a document with NAMES in column A and ROLES in column I. If the user has more than one role..their name will be listed in "A" for each role in "I". I'm trying to purge down a file that has 60k + rows. Lets say i want to see all the people and all their roles if they are in "PROGRAMMER_ANALYST" role...can this be done by macros? or formula?

View 2 Replies View Related

Worsheet Cell Does Not Show Correct Answer

Apr 6, 2008

I have 2 worksheets (worksheet 2 is Slicing and Worksheet 1 is Production).

Production worksheet D6 has a dropdown box for, 1, 2, 3, 4, 5, 6, 7, 1.1, 2.2, 3.3, 4.4, 5.5, 6.6 and 7.7.

In the Production worksheet, I have in cell E6 =IF(D6=1,"ONE",IF(D6=2,"TWO",IF(D6=3,"THREE",IF(D6=4,"FOUR",IF(D6=5,"FIVE",IF(D6=6,"SIX",IF(D6=7,"SEVEN")))))))

In the Production worksheet, I have in cell F6 =IF(D6=1.1,"ONE",IF(D6=2.2,"TWO",IF(D6=3.3,"THREE",IF(D6=4.4,"FOUR",IF(D6=5.5,"FIVE",IF(D6=6.6,"SIX",IF(D6=7.7,"SEVEN")))))))

How do I show in Slicing worksheet cell B6, either 'ONE', 'TWO', 'THREE', 'FOUR', 'FIVE', 'SIX', 'SEVEN' as i have the formula =PRODUCTION!E6&PRODUCTION!F6 and the cell shows '

View 9 Replies View Related

Formula To Show Combine Answer And Text In 1 Cell From 2 Different

Oct 27, 2009

i need t oknow if i can have text added into 1 cell with having a formula with a answer in it as well,,,i have attached a sheet with better examples of what i mean.

View 3 Replies View Related

Selecting Multiple Row For Sorting

Dec 23, 2008

I am trying to select multiple rows so that i can sort. The code i have

View 2 Replies View Related

Selecting Row With Multiple Conditions?

May 31, 2014

I am trying to copy rows to a new sheet that meet a couple of conditions.

They have to meet condition 1, 2, or 3 and conditions 4, 5 and 6. Meaning have any of those search terms listed in columns L, M, N columns, but no terms in columns I, J, or, K.

Sub filter_data()
Dim rng As Range
Dim header_pos As Integer

[Code]....

View 2 Replies View Related

Selecting Max Value From Multiple Records

Jun 18, 2007

I need to select the record that has the highest number in column C by using an input value like (red).

desired Result : red, gt3, 100

A..............B...............C
red..........rt2.............12
green.......rt3..............4
red..........st2..............33
blue.........st4.............45
green.......st1.............44
red..........gt1............100
blue.........ft4..............85

Is it some variation of the MAX function?

View 9 Replies View Related

Logic With Multiple Cells, Selecting Between The Two

Jan 16, 2009

I'm working with Excel 2003 on a peice for work that requires users to enter their current grade and, if they have one, a temporary grade. Another sheet in the workbook needs to add together all those in a certain grade and who answered a certain way to a drop-down table, so that I can use it to figure out what percentage of staff are of each grade. At the moment it looks like this:

=SUMPRODUCT(--(Work_Data!F2:F9827="Grade 1"),--(RIGHT(Work_Data!K2:K9827,3)="Top 25%"))

Which only draws information from the current grade (column F) and the answer they give (Column K). What I can't come up with is a formula that will only take column F as long as column G hasn't got a temporary grade, but if it does have a temporary grade will take column G instead.

View 4 Replies View Related

Automatically Selecting Multiple Cells?

Nov 2, 2013

When I click on a cell, for example T13, cell U13 will also automatically be selected. I have looked everywhere for something that is making it do that, but can't find an answer.

It doesn't happen with every cell. I have to do some more clicking around to see if there is a pattern.

View 1 Replies View Related

Programmatically Selecting Multiple Shapes

Feb 16, 2005

Trying to select multiple shapes based on shape properties. The missing piece is the code to select the shapes. The examples in the help use the 'Array' function with a list of shape names.

Is there a way to select a random set of shapes without using the Array function?

Or how does one build a list for use with the Array function?

View 10 Replies View Related

Finding And Selecting Multiple Cells

Jan 21, 2010

I'm working on a macro that's supposed to copy certain cells from a sheet, and paste them in another. But the problem is that I can't find a way to get them all in one go. The sheet that I am copying from has a mile-long list that looks something like this:

OR0220018NO-RING 21,95 x 1,78 N270 BS-0205,00
OR0220018N90O-RING 21,95 x 1,78 N290 BS 02022,00
OR0220018VO-RING 21,95 x 1,78 V275 BS-02010,00
OR0220018V90O-RING 21,95 x 1,78 V290 BS 02013,00
OR0220020NO-RING 22,00 x 2,00 N2709,00
OR0220020VO-RING 22,00 x 2,00 V28024,00
OR0220025NO-RING 22,00 x 2,50 N2705,00

It goes over 3 columns. I want to select column A, B and C in every row that contains the letters "N270".

View 2 Replies View Related

Selecting Values In Multiple Colums For A Sum

Mar 5, 2009

I am trying to create a spreadsheet to select different values. I have 5 columns with type A values then 3 cols with type B values, a blk col then 1 cols with type B values and 5 cols with type A values then 1 cols with type B values and 2 cols with type A values a blank 1 col with a B value, 2 cols with A values and 2 cols with B values. [ A A A A A B B B Blank B A A A A A B A A Blank B A A B B ]

I need to select 5 lowest values from this set but a minimum of three A values need to be used. I have used the min, small 2, small 3 for the A set then used an IF statement for the fourth value. The formula returns the correct sum for values up to the fourth value. The problem comes on the fifth value. I am attaching the formula I started with.

=(MIN(F3:J3,R3:T3,V3:W3))+(SMALL((F3:J3,R3:T3,V3:W3),2))+(SMALL((F3:J3,R3:T3,V3:W3),3))+(IF((MIN(K3: M3,U3)<SMALL((F3:J3,R3:T3,V3:W3),4)),(MIN(K3:M3,U3)),(SMALL((F3:J3,R3:T3,V3:W3),4))))+(IF(SMALL((K3: M3,U3),2)<SMALL((F3:J3,R3:T3,V3:W3),5),SMALL((K3:M3,U3),2),(SMALL((F3:J3,R3:T3,V3:W3),5))))

View 4 Replies View Related

VBA For Selecting Multiple Nonadjacent Columns

Aug 8, 2009

in a vba module I currently have this

View 2 Replies View Related

Selecting Multiple Worksheets - Sort All

Mar 14, 2012

The code im using all worksheets. How do I make this sort all but the first

For Each WS In ActiveWorkbook.Worksheets

If WS.Name "Sheet1" Then

Range("A1:X2270").Sort Key1:=Range("A2"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

View 1 Replies View Related

VLOOKUP Selecting Multiple Columns?

Sep 11, 2012

i have the following table, i want my Vlookup not only get the description from Column K but to get column K , L , M City and Country as well and put them in Columns D for Description, E for City and F for Country. would this be possible with Vlookup formula or any other formula?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved