yes/no

Hi, I am a beginner Excel user and I have been researching a problem. I cannot figure it out so I thought I would ask this forum. I am looking to combine a COUNTIF and an IF statement into one formula to arrive at my answer (Yes or No) for a survey type of project. Basically, I want to count...

Hi I know how to protect workbook in vba using workbooks(1).protect workbooks(1).unprotect What I want to do is to ask user this question: do you want to protect workbooks? yes/no If user say yes then I do wrokbooks(1).protect If user say no then I do workbooks(1).unprotect Any idea how...

Help Please! I am trying to populate column F based of the information in columns A-E. The cells I have labeled as Yes/No will initially be blank and will have a data validation to be either Yes or No. An ideas are most appreciated! <tbody> A B C D E F 1 Build Yes/No...

Hi. I have a table with three fields: ID, Full Name, yes/no I then have two queries: One query is using this table to see "yes" and the other is looking for "no". But whenever I attempt to run the queries, it tells me there is a data type mismatch. I am unsure what I am doing wrong!

Hi All, I have a sheet with names across the top and then training records for each person below their names. What function/formula do I need to use in order to return a yes/no value if a person has completed a particular training course? Thanks in advance.

https://app.box.com/s/jcxrsue4vuzhnjzqhvzdfkdon20n1sm5 In columns ABC are digits ranging from 0-9, I need a formula yes/no that tells me if the largest digit is equal to the other 2 digits.

Hi An odd issue, that only seems to happen the first time you try and as long as the first time shows the lower options - once you move away from the cell and then re-try it works as expected. Unusual Behaviour Following Validation List Selection So I have a series of Yes/No validation list...

I am having a difficult time figuring out how to have a yes/no messagebox selection open another yes/no messagebox. Is this not possible and I need to use a userform?

​Hi guys i have the data below which defines the rule of YES/NO and Final Outcome <tbody> <tbody> name set status action YES/NO Final Outcome TRUE TRUE yes install FALSE TRUE yes close TRUE FALSE no fix TRUE TRUE no freeze yes leave </tbody> </tbody> I need a If...

Hello there, I have a Hyperlink in Cell E5, to generate an email. What I would like is to have a command button linked to the text but cannot work out how. (Additionally, I would also like VBA code to link to a msgbox, so when the user exits the spread sheet it will bring up a message with...

I’m self-taught in MS Access and haven’t done much with 2010 since I learned a long time ago in 2003. So please don’t hesitate to be explicit I have thick skin and can use the direct guidance. I have a table that contains all the data for the dates in which a person is to be paid out there...

Hi, A product can either be for surface use or for subsea use - not both at the same time... <tbody> Surface Yes Subsea No </tbody> I have made Yes/No selectable from a dropdown. But... These two fields (B1 vs B2) must be of opposite values... Ie. If I select B1 as Yes, then B2 should...

Hi, I have two columns in a spreadsheet - one is a year and the other a data validation field yes/no. I want to count the number of instances of yes/no by year so wrote the following formula =COUNTIFS(QNSAPList!$W:$W,"2011",$X:$X,"Open"). However, it's returning zero. Can anyone tell me what...

Hi all, I have an excel question which I've been scratching my head about... I've had a few attempts at solving this from butchering various bits of VBA I've found, but although it works (still with a few bugs to be ironed out), I'm confident there's a better way of doing this. So, here goes...

Hi All, Quick presentation as it's my first post on this forum: I'm 28 and working in Controlling for a large French company in Singapore. I've been reading this forum for a few years now and always managed to use existing threads to find my way with my codes. However I could not find what I...

I have looked at this data for too long. :eeek: Here is my survey data: Team Name Q1 Q2 Q3 Alpha Yes Yes Yes Alpha Yes No Yes Beta Yes Yes Yes Beta Yes No Yes Beta No No No I'd like to total the number of Yes/No responses for each team for each question...

Good day, I have the following code in a userform, which worked fine until i tried to put in a yes no function. I need the code to run and check if the are any duplicate names, which it does, if a no duplicate names are found then add the data. However if it finds a duplicate name then it...

OK, so I'm creating a form that has a series of questions all requiring a Yes or No answer. I was happily putting in a series of group boxes with Yes and No option buttons inside when I realized a couple things: 1.) I'd want the user to start out with NEITHER Yes or No checked 2.) Users will...

Hello,</SPAN> I am trying to create an IF statement for my “Notes” column but I can’t figure out how.</SPAN> I have 3 Yes/No Columns that show exceptions - LoanExcept, AddrExcept,GARExcept. I’d like to populate 1 Note field that indicates which columns have a “Yes” - see example below.</SPAN>...

Hi all, Im a newbie here and really struggling. I have a master list of products eg. code product vegetarian contains gluten 1234 tomato Y N 5678 bacon N N 2468...