# Comparing Text In Cells..?

Jan 26, 2005

I have a spreadsheet that has long text sentences in each cell. I have a 2nd spreadsheet which is a slightly updated version of the first spreadsheet. The slight updates consisted of editing the odd word here or there out of the first spreadsheet.

Unfortunately, I didn't keep track of the changes I made, and I need to know what they are.

It's easy to tell if a change has been made, simply by comparing the cells. But I can't find an easy way to find out exactly what change was made. Comparing the cells a line at a time is very time consuming.

## Comparing Text If Some Cells Can Be Empty

Aug 13, 2009

I need to compare some cells, but sometimes one or two cells can be empty (but sometimes none of them)

e.g. A1 = January
B1 =
C1 = January
D1 = January
E1 =

and I need to compare this cells A1:E1 and if text in not empty cells is the same then write TRUE to F1 and if not write FALSE.

## Comparing Text Values In Two Cells And Adding 1 To Result Column

Apr 14, 2013

I have an excel file with some data in it. I have two columns with one of four words in it. For simplicity I'll call them RED, GREEN, BLUE, and Yellow. A few columns over I have columns "Same" "Good" and "Bad". I'm trying to figure out a way to get excel to put a 1 in the appropriate column, if cell A1 is Red I need excel to look at the word in cell B2 and put a 1 in the "same" column if A1 and B1 are the same word. If the word in B2 is Yellow I need excel to put a 1 in the "Good" column. If the word in B1 is GREEN or BLUE I need it to put a 1 in the bad column. The tricky part is each of the four words RED, GREEN, BLUE, and Yellow have a different set of words that will be called "good" or "bad". So if the word in cell A1 if Green for example it will have a different set of good and bad color words.

So it seems I need four different functions depending on what word is in A1. In the column next to these lists of words I have the date which I'll need to use to give me the sums of same, good, and bad for each day. But first things first. I think I need to use a combination of IF functions and MATCH function, but I can't figure out anything that works. Below is what I'm hoping it will look like when I've got the right formulas.

First column
Second column
Date
Same
Good

[Code]....

## Excel 2010 :: Comparing Cells And Displaying Text Dependent On The Results?

Aug 15, 2012

I have attached a work book example of what i am trying to do.

Column D is what i originally did in terms of the formula and now i have to have a column display text dependant on what is in column A to C.

I was trying this formula =IF(b2>a2,"Start Target Missed",IF(c2="","Failed","Tracking")) However if this isnt working.

Is there anything i can do to change this?

## Comparing Customer Names In Rows And Returning Text Data In Different Cells If Same

Jan 26, 2010

I've got a list of donor names, names listed multipled times in Column A, each row with different donation data. For instance:

Sheet 1

A1 - Mary Jones, B1- Internet Donation
A2 - Mary Jones, B2 - Silent Auction Purchase
A3 - Mary Jones, B3 - Event Ticket Purchase
A4 - Gary Jones, B4 - Foundation Grant
A5 - Gary Jones, B5 - Internet Donation
A6 - Sara Parker, B6 - Event Ticket Purchase

I want Excel to compare rows A1 and A2, and if the name has not changed, enter the donation data from Column B into another sheet that will just list that person's name once:

Sheet 2

A1 - Mary Jones, B1- Donation1, C1 -Donation2, D1 - Donation3
A2 - Gary Jones, B2 - Donation1, C2 - Donation2, D1 - Donation3 (which would return no value because there the name changes

Does this involve IF, MATCH or VLOOKUP formulas?

## Comparing Two Cells Based On Text, Font, Colour, Font Size Etc

Jun 3, 2006

I'm looking to set up a spreadsheet whereby individuals answer questions and have to format their answer using a particular font, colour, font size and so on. The idea is that I can then compare their answer sheet to a pre completed one using an =IF function and get a total score. The only problem is =if and =exact only lookup cell text/numbers and don't look at how the text is formatted within them.

## Change Text Color When Comparing 2 Text Fields

Aug 20, 2013

How would I compare two text fields (old and new) and change the font in the 3rd column (Difference)?

For example:

Old: I can not figure 3 things out.
New: I can't figure 2 things out.
Difference: can not can't figure 3 2 things out.

## Comparing Text In Same Cell?

Jul 14, 2013

To make a long story short, I'm trying to compare formulas. I was able to copy the formulas as values.

There are hundreds of lines, each one with the formulas pasted as values, like '=SUM(G132:I132) / G30. What I want right now is to compare the text.

So, if for example:

the line for both parts of the pasted sum formula like '=SUM(G132:I132) / G30, I want a number 1 to be written in the adjacent cell (if '=SUM(G132:I132) / G30 is in A1, 1 should be written in B1).

However, if its is written '=SUM(G132:I142) / G30, than nothing should be written in B1.

Moreove, the line could have from 1 to characters. So it could be '=SUM(G1:I1) / G30 or '=SUM(G13200:I13200) / G30.

is the same, like of A1 is '=SUM(G1322), I want a number 1 to be written in B1

## Comparing Text In 3 Columns?

Jan 28, 2014

I need to compair 3 columns of text and return a value in a forth colum. example:

If cell D2, E2, & F2 all = “Failure” return “PASS” in cell I2
If cell D2, E2, & F2 all = “Pass” return “PASS” in cell I2

If any other combination exist return “Fail” in cell I2

## Comparing Text Files In VBA

Dec 3, 2008

I have two text files with huge data in each which I need to compare for difference between each
for e.g.

file 1 would have following records

12345 KKKK 3510 ABCD

file 2 would have
12345 KKKK 3210 ABCD

file 2 would have similar records but 3510 would have difference. What i need is " if 12345 and ABCD is matching then what is the difference value of 3510 and 3210 ? the result should be 300 . This i need as an output in another text file.

## Comparing Columns Of Text And Calculating A Value

Oct 20, 2009

I work in a School and need to create a points awards system based on GCSE Grades.

I have predicted and actual grades for each pupil in columns. I need to figure out how I can calculate an award point for this. i.e. if the predicted grade is an A and the Pupil gets a C this would be a minus 1 point score. I need to do this for all subjects and add a total.

I have attached a spreadsheet with a demonstration of what I require. I have created formulas to do what I require however I see it as terrible programming but I cannot figure out another more efficient way.

## Vlookup Comparing 2 Text Lists

Dec 2, 2008

I have two separate columns of text and want to identify similarities/matches. vlookup false is good for exact matches but vlookup true is too approximate - is there a way to hone vlookup true to match first 4 or 5 text characters rather than just the first? If vlookup no good for this what is best function for identifying approximate matches in two separate text lists?

## If Statement Failing When Comparing Text Box Values On Userform

Jun 12, 2014

I am trying to compare to values that a user inputs in a user form. It's ok if they are not the same I just want the user to know it. I am only including the part where the if statement is failing:

VB:
If Me.VSLongQuant.Value <> Me.VSShortQuant.Value Then
MsgBox VerUnBal
If VerUnBal = vbNo Then
Exit Sub
End If
End If

I have VerUnBal as Long and defined as:

VB:
VerUnBal = MsgBox("The Long and Short option Qunatities are not equal." & Chr(13) & _
"Is this intended to be an unbalanced vertical spread?", vbYesNo, _

I can provide more info as necessary. There are two problems 1) the message box is appearing whether the numbers are equal or not, and 2) clicking No in the message box does not cause the Sub to exit.

## Comparing Grades (text) To Give A Numerical Score

Nov 3, 2009

I am creating for the pupils at my school. Comparing the grades they were predicted and have achieved I would like to give them a score.

I have already achieved this but it means wasting 3 columns for each subject to work it out. The ambition is to do all the working out and assign a point score value in 1 column.

The spreadsheet it attached if anyone would be kind enough to have a look and see if there may be a formula which will do what I need.

## Comparing The Cells

Apr 6, 2009

I have two spreadsheets I would like to compare against each other, last weeks inventory (Sheet 1) and this weeks (Sheet 2). All items are listed by unit number, is there a way to have all unit numbers on Sheet 1 colored red that are not on Sheet 2 and vice versa?

## Comparing Two Cells

Nov 16, 2009

Is there a way to compare two cells and return true if they are the same, false if different? There is text and numerical data. As a side note, can anybody recommend a lightweight reference so I can sit for an evening or two and at least get an idea of what excel can do?

## VBA: Comparing A Value To Several Different Cells

Jun 8, 2006

I need to compare a value to several cells and print the value into a new cell if and only if the value is not in any of the cells I am comparing to.

Say cells A1, A4, A8 and A12 contains different numbers. I want to compare a value, say 120, to the values of the above cells and if it is not contained in one of those cells I want to enter 120 into cell A16. If A1, A4, A8 or A12 contains the value 120 I want to leave A16 blank or write 0 to it.

Is there an easy way of doing this? Right now I am using a if-test for each of the cells I am comparing to, but this gets very messy as the number of cells increases.

## Comparing Two Cells With Another

Mar 16, 2007

how to compare two cells (say, today's date with the date an order was supposed to be sent out), with a third cell that either has a tick in it, or nothing. If there's an easier way to do this other than VB code, I haven't found it. I tried conditonal formatting but it wouldn't let me have a condition in which it just checked the third cell, it needed to compare it with the selected one.

## Comparing Multiple Cells

Feb 11, 2009

I have two excel files. The data is arranged by column. I want to take 3 or more cells (from three different columns) from a particular row and match them up with three cells (in 3 different columns but in the same row). The three cells should be in the same row. However the matching row may appear in a different order in each of the two lists. When Excel finds a match, I want it to return true. How can I go about doing something like this?

I have attached a file explaining what I mean. I am trying to match the three cells in list one with three cells in one of the rows in list 2. However the number of cells in each list is different and there are some cells in list 2 which are not in list 1 and vice versa. There may also be extra columns, which I have not included for the sake of simplicity.

## Comparing Sheets (cells)

Apr 6, 2009

If u dont mind can i have example xls file please.

i hope u guys will help me to improve my knowledge by uploading attachments ...

## Comparing 2 Cells To Return A Value

Nov 17, 2009

I have column a,b,c. b and c both contain numbers. if cell c1 equal b1 then i want "new" to be displayed in a1. If it does not equal then i want "old". but if c1 is blank then i want a1 to remain blank.

## Comparing The Same Cells In Two Worksheets

Aug 22, 2008

I would like to make a macro which compares the content of the same cells in two worksheets which are in the same workbook.

More clearer I have a workbook with two sheets (Sheet1 and Sheet2). What I would like the macro to do is to check cell A1 in Sheet1 and compare it to cell A1 in Sheet2 and so on till the last cell (IV65536). If there is a differnce between the two cells, then it should highlight the background of the cell in Sheet1.

I know that there has been similar requests on this forum (I searched and read them) but thew were different.

## Comparing Certain Numbers In Two Different Cells

Nov 7, 2008

I was wondering if someone can at least point me in the right direction with respect to comparing two numbers within a value in two different cells. For example:

If one cell has the value "AB123456"
And the cell below it has a value of "AB124658"

I want to be able to determine the difference (with VBA code) between both cells by just looking at the fourth and fifth characters ("23" and "24", respectively) in each cell value.

## MACRO Comparing Cells ...

Dec 21, 2006

I have a Workbook with two Sheets MAIN and STATS

Col A in both sheets contain text values (names)

I need a macro which will:-

Look at each name in Col A MAIN sheet.

See if there is a match in Col A of STATS sheet.

If there is a match then enter "YES" in Col E

e.g Smith Eddie is is in the Cell A20 MAIN sheet, Smith Eddie is in Cell A55 STATS sheet, so Enter "YES" in Cell E55 STATS sheet.

## Comparing Two Cells With Dates In VBA

Dec 12, 2009

I have trouble trying to get the right sintax of comparing two dates locates in two different sheets.

Example:
Sheet 1, cell A1 = 12/11/2009
Sheet 2, cell B1 = 12/11/2009

If I need to do something based on condition that Sheet1 date = sheet 2 date, how will the code be written? I have

If Sheets("Sheet1").range("A1") = Sheets("Sheet2").range("B1") Then
**** my code here

## Comparing Cells And Return Number?

Apr 23, 2013

Thing is, I have an excel sheet for a private competition in sports games. How can I do a function, that automatically calcutes points for every "bet" against the game result?

For example:

If game finishes 4-3 I'd like to compare it for every players guessed score and give points according to this:

1. If the bet is completely correct (4-3) -> Return 10 (points). In case of tie (like 3-3, -> Return 20 (points)
2. If the bet has a correct winner, with correct goals for eather team (4-x / x-3) -> Return 4 (points)
3. If the bet has a correct winner (home/visitor) -> Return 3 (points)
4. If the bet has incorrect winner but amount of goals for eather team correct -> Return 1 (point)
5. If the bet is completely wrong -> Return 0 (points)

At least for me, this sounds more like rocket science but just wanted to check if this is anyway doable.

## Comparing List Of Cells To Each Other Using Macros

Jan 28, 2010

I have a list of authors for about 20 papers. These Papers are listed in sequential order from 1999 to 2005.

I want to track the number of similar authors from paper to paper. Thus I am attempting to create a macros that has the Papers listed sequentially when they were published and the authors for each paper, with the authors name in each cell. I want to create a macros that will compare the Author Cells associated to lets say the Fifth Paper with the Author Cells for the Fourth Paper (the Previous Paper). So that if certain authors come up in the Fifth Paper that were in the Fourth Paper, the # will be noted.

I also want this macros to compare all the Author Cells that have appeared in the past with that of the author cells of the (N) paper excluding the (N-1) Paper, and just note the # of occurences. So using the previous example. If we are talking about the Fifth Paper, it will look through Papers #1-#3 for any matching keywords and note the number.

I have attached my spreadsheet to make it more clearer. For some papers there are more than 20 authors as well just to note.

## Comparing Multiple Cells To The Same Array?

Feb 26, 2014

I am trying to find compare the value in one cell with an array of cells. My problem is when I try to carry the formula down to the next line - my array changes as well. For example:

Before
After
01915

[Code].....

So, if Before is Column A and After is Column G, the formula I have right now is =INDEX(A2:A3349,MATCH(G2,A2:A3349,0)). When I try carry the formula down to G3, G4 and so on, the array changes as well.

## Sorting Rows By Comparing Cells ...

Mar 13, 2007

the system works by whoever has the most points wins.. i already have my formulas and everything done..

i want the excel program to move the entire row, if possible, by whoever has the most points to the top..

(i.e If ryan d. has the most points he will be is vince v.'s spot)

can this be done automatically in excel or do i have to do it by hand?

## Comparing 3 Cells As Equal Or Unequal

Mar 27, 2007

Columns E and F can have a 1 or a Zero
If e2, d3, e4 = all 0's or all 1's, count = 3 in col F
If either e2, d3 or e4 is not equal the count is 2 in F

Example

D E F
0
0
0 3
0 1 2
1 1 2
1 1 3

Also, why would this formula work with numbers but not letters?

=IF(B2="x",0,IF(C2="x",1,""))