Find Cell That Contains Certain Text And If It Exists Compare 2 Other Cells
Jun 25, 2013
I've a spreadsheet and I need to find cells in Column A that contains certain text and subsequently being able to compare the data in 2 other cells (column F and Column J) and post the results of comparison in Column L. Please see the tables below:
In this table, if Range("A1") contains abc, then data in Range("f1") would be compared against Range("J1"). If F1 = J1, then Range("L1") would say "ok" otherwise "needs to check" as in Rows 2.
I have a if function that i am creating in excel 2000, and it has 8 variables. I am trying to put it in a macro as it is not working as a nested if function. Here is the current if function...
I have a workbook with tons of programming I need to achieve. Here is my work book so it can be viewed.
Right now on "Protocol" Sheet I want the cells with the "Protocol 1" field to look at Admin_Panel Sheet and find the row with the same text. Then take the text in cell A of the same row and copy it to the cell below the "Protocol 1" listed on the protocol sheet.
What I want is to find out whether a value in a node can be found from a group of other nodes. I've tried lupike this, but it doesn't seem to work properly.
I guess one solution could have been using concatenate function, but why on earth can't I use the function like this: concatenate(A1:A5)? Why do I have to put each term individually?
trying to find the value of column A (date field) if it exists on the row that the cursor is presently on. I'm trying to check for the value before performing the next function to make sure the user is on a valid row. Cursor could be on any column A to F. Columns are always 6 but the rows can vary.
One has numbers the other has "YES" or is blank. I want a formula to look at the second column and where there is a "Yes" then count the number in the same row in the first column.
I am trying to find particular text in a cell then format adjacent cells in the same row. In my code below I am trying to search for "*[Tx]*" using Like, however this is formatting all text that contain "T".
Let me see if I can make this succinct and clear. Cell AQ2 (where the formula below resides) looks at the value in cell E2. It then references table $K$3:$U:$100 on sheet "LookupTables" to get the value to display. It does this (and works great) with the formula below:
I would like to add one more argument. I would also like it to reference cell U3 in the LookupTables sheet and if there is anything in that cell to go ahead and complete the formula, but if there's no value in that cell, it should return no text and be blank
Basically, 'Atlantic Ocean' is 100% different from the cell above, but A2 has only one letter different (out of 18, including the space and the dot) compared with A1, so it's only 5.55% different.
This would help me find which cells that are supposed to have the same content, have errors and thus are slightly different.
As per title, I am trying to compare a column of text cells which contain "Yes" or are empty and a columns of numbers. If they are "Yes" and "1" on the same row, I want to output an "OK" message. Excel seems happy with the following code but it does not work and returns an empty cell if the two conditions are true.
how to Chk the text string in particular cell, compare it with a super set column and get the full from of the text string from another corresponsing column and the output will be corresponsing full form of the chked text string?
I have one sheet and i want to compare the first word in the column "D". If the first word of D2, is the same than the first word of D3, i want to copy to another sheet and after the copy, insert 2 blank rows... if it's different, i want to copy and insert 3 blank rows
Maybe it's better to attach the file. In the first sheet, you'll see a little part of the real sheet, and the second sheet is the example of what results i want to obtain with code...
I am trying to write a function that will compare the text of cell "A2" to the text of cell "B2" and display cell "A2"'s text characters that didnt match from cell "B2" in column C. Can anyone help me out with writing this formula?
I am trying to write a macro and i am having trouble hgetting it right. I have large amount of data in columns and what I would like to do is the following.
1. First I need to find the first blank cell in that row.
2. After finding the blank cell, I would like to compare the value in 3rd column from the blank cell( For example if the last blank cell is Row1,ColumnR then I need to Compare Row1,ColumnO) with Column E ( Is always Column E).
3. Based on above example if Row1,ColumnO>Row1,ColumnE, then goto next row else Row1,ColumnR value should be Row1,ColumnE and I would like to get Row1,ColumnS and Row1,ColumnT vaues to be same as last 2 columns from the blank cell which was determined first (i.e., from above example Row1,ColumnS and Row1,ColumnT vaues to be same as Row1,ColumnP and Row1,ColumnQ).
4.I would like to perform the above procedure for all the rows in the worksheet and the blank cell may be anywhere in the column for that particular row.
I don't know whetehr it is possible to write a macro to perform above procedure or i need to do that manually which i hate as i have large amount of data.
My requirement is compare two cells a1 & a2 if found true highlight a2,compare a2 & a3 if found same highlight a3 or compare a3 and a4 and repeat the same for the entire sheet.
Is it possible to compare code that's in two cells and show the differences? It's possible with Notepad++ and an extension but I have hundreds of pages to examine weekly and it's not efficient to do it manually.
I want to search for a word in column A and when I find it I want to copy it to column B. Column A is a description that can be 6 or 7 words long. Column B is a single word.
Example:
Col A Engine Kit, V-8, 306, forged. I need to copy the word Kit to column B.
The value stands for the Periodnumber and a Year so P1'08 stands for period 1 in the year 2008.
In cell H2 I want the following:
If value in cell H1 is the same as B2 or C2 or is in between these periods then the value in H2 should be the value of cell D2. If not the H2 should be empty.
Looking for formula with if then statement that involves a nested formula or concatenation. I need a formula that says: If cell A reads exactly ABCD then concatenate cell A with cell C. Very basic to most of you gurus but I'm fairly new with formulas.
I am having trouble getting my IF statement to test if the cell contains the text "sale" return "X" if not "Y". I need it to search through the text string in that cell and find a certain word, and if it finds that word, retrn a value. I am really having difficulty with is what symbol or function do I use for the logical test? (i.e. =, <>, MATCH, INDEX?)
I'd like to compare two cells, and if the first cell is either >150, <161, OR =165 AND the second cell is ="E" to output a 1, and if false, output a zero. I have =IF(AND(AND(Sheet1!B3>150, Sheet1!B3<161, Sheet1!B3=165 ),Sheet1!E2="P"),"1","0")
But i know that is incorrect because Sheet1!B3 can not be greater than 150 AND less than 161 AND = 165. I can't figure out how to make it >150 AND < 161 OR = 161.
I am trying to add a third if statement to my existing code looking to see if a cell in a column is blank and the corresponding cell in another column contains a number that is greater than or equal to 1. I can't figure out how to write that part of my IF statement.
If Cells(r, 4) = " " And Cells(r, 3) >= 1 Then Cells(r, 1).Resize(1, 5).Interior.ColorIndex = 35 Set rng = Union(Cells(r, 1), Cells(r, 3), Cells(r, 4)) rng.Copy Worksheets("Sheet1").Range("G40:I40").End(xlUp).Offset(1, 0).PasteSpecial (xlPasteValues) Application.CutCopyMode = False Cells(r, 5) = "NEW" End If Next r
I have a spreadsheet with 2 worksheets. On the first "active parts" I have a list of active part numbers and on the second "All Parts" I have all of the parts available.
I want to compare every part in the All Parts worksheet to see if the part number exists on the Active Parts sheet - if it's there, I would like it to return the value "Active" in column B in All Parts. I have a formula in column B in All Parts that seems to work for the first few, but as soon as it finds one that is active, the rest of the cells below all return "Active".
