I am trying to develop an IF formula. I have 4 cells with eother "yes" or "no" in them. I would like a formula that looks at the 4 cells and returns a message in another cell of "test" when 2 or more of the cells have "yes" in them. Can anyone assist me?
I have the following test code that is working where column H is equal to what's in column B versus column D
Range("H2:H17") = "=INDEX(D2:D17,MATCH(B2:B17,B2:B17,0))"
Column B Column D Column H
A Test1 Test1
B Test2 Test2
C Test 3 Test3
D Test 4 Test4
E Test 5 Test5
F Test 6...
<a href="https://fhexcelphotos.shutterfly.com/pictures/9" target="_blank">https://fhexcelphotos.shutterfly.com/pictures/9
Please bear with me as I am not a programmer and therefore aren't fully competent with the terminology or...
Shown below is a simple table showing a list of students and their grades for tests they periodically take. I send the results to them so that they can see how everyone is performing without knowing each others scores. I would like to automatically anonymise the columns each time I send...
I have one column with words, and another one with sentences. I want get into knowledge, which sentences from the second column contain words from the first column, putting into the third column something like "contains / not contains". Case insensitive could it be.
Hello! I'm trying to solve the following issue using an array formula but I'm struggling. I'm fairly versed with arrays but can't figure this out. Thank you in advance for the help!
Using the example below, I'd like to pull the max number associated with each individual text in the first...
I have two tabs. [TAB1] is where I want to place my results. I want the results starting in columns C and moving right, as many columns as need be. I am hoping I can limit the columns the results section will be by only returning unique results (i.e. if there are three reference IDs...
I have a database containing hundreds of students. That database has student ID numbers (column A), student last name (column B), students first name (column C), test scores (column D) , and test date (column E) as shown below. I want column F to display the student's ID number, column G, the...
I have a table with multiple columns. I am wanting to search one of those columns to find if there is a value > 0. If so, I want it to return back to a main table dashboard that value in one column and in the second column, it will return the number in the column it was searching. It would...
I have a button to update a powerquery on Sheet 2 from another workbook. the number of rows of data will vary.
Now i want to include VB script on the button to update data on Sheet1 based off the data imported.
What I am trying to accomplish.
if Sheet2 column A has an entry that MATCHES Sheet1...
I have this value (95551092 - ) in the activecell and I would like to add whatever value is in cell A50.
I do have the following code which adds the value but it deletes the spaces and then moves the hyphen in front of the numbers.
Dim d As Double
d = ActiveCell.Value...
I put two option buttons on a form and I am trying to figure out how to use them. Where is the Value stored when one of the Options are selected? I want to use these buttons in an If statement.
I tired to test it:
Private Sub Frame244_Click()
If Option246.Value = "1" Then...
I think I got myself twisted up here. The idea is to replace one of the Pass/Fail columns on the right with a code that leaves the portion IF(COUNTIF(C27:Q27, ">"&$O$18), "FAIL", "PASS") intact...
I have the following in D2 which contains "David & Rose Smith
I want to test for strings listed in the named range, "NOGOOD".
If none of the string are in C2, I'd like to apply above. If any of the stings in NOGOOD appear in C2, the result...
I've been having trouble getting global variables to work.
Option Explicit Public Test As Variant
test = 2
Option Explicit Sub Testing()
test = 3
All i want is to throw over my test variable value and update it...
I have a table of names as columns and skills matrix as rows for each name. However, I am now trying to move each column (name) to row and repeat all of the skills matrix for each name eg shown below. I have Names listed from Col B to Col W and may keep on increasing and changing and have...
I'm having problems understanding how to designate a specific file path on this line of code.
This works as long as the file is one folder before \old reports..... As soon as the file is moved the code no longer works.
I would like to be able to hardcode a folder such as...
I'm looking for some code that will:
1. Evaluate my data set in my "test" worksheet. The header for my data set begins in worksheet("Test"), cell A3, and the size of the data set varies weekly.
2. Create new worksheets (and name the new worksheet) based on the cell content is the...