# Tagged Questions

**-1**

votes

**0**answers

18 views

### comparing two excel documents to match row color of first document

say i have two excell documents, .... one was sorted manually the day before, and then color coated in certian colors based on certian criteria, and the next day a different report comes out that ...

**-1**

votes

**2**answers

28 views

### Comparing two columns and extracting the entire row data in excel

The names from a column in sheet1 has to be compared with names from a column in sheet2, and the if a name matches, the entire row data of that particular name from sheet2 has to be displayed in ...

**0**

votes

**2**answers

19 views

### Excel - Compare two cells and display the larger number?

Can someone tell me how to compare two cells (numbers), and then display the larger cell?
Cell C1 = IF A1 > B1 then display A1 else display B1
Sorry I'm not an excel pro.

**1**

vote

**1**answer

104 views

### Excel, compare cells in different sheets in a workbook

I am a real nooby and I have some questions.
I have 5 sheets (A,B,C,D,E). Each sheet has numbers in it (10 rows-15 lines) A1 to I15
Now I want to make a 6th sheet in which I can compare the cell ...

**-1**

votes

**2**answers

45 views

### Excel - comparison of text between two columns [closed]

How do I compare two or more columns in an Excel worksheet to identify the difference. The comparison of two columns is related to text and not the numbers. Please advise.

**0**

votes

**2**answers

41 views

### Excel If Statement always shows false

I can't figure out why the result is Y, even if the cell H22 has the value of 4. Shouldn't it be X ?
=IF(H22="4";"X";"Y")

**0**

votes

**1**answer

73 views

### Comparing two excel table (and matching two columns in each table)

I'm trying to do the following.
Table A includes two columns, if two items from the same line (one from each column in A) appears in one line in column two this line should be marked in Table A.
So ...

**0**

votes

**0**answers

29 views

### Excel String compare [duplicate]

I am trying to compare string and then display the what doesn't match between the two of them, for example:
take A1 which contains [alpha:beta] and then B1 which contains [alpha] and it will match ...

**0**

votes

**1**answer

383 views

### EXCEL populate a list of sunday's dates and ignore the sundays in an exception list

Hi i'm working on a sheet which i have to populate with sundays dates, and make sure that dates from an exception list don't be present in my final list
Goal: is to have the list of dates of only ...

**0**

votes

**2**answers

72 views

### Compare cells based on dropdown

I have multiple products, each with various features. I would like to choose a product from a dropdown list and then populate its features below, then do the same for a second product next to it.
My ...

**0**

votes

**1**answer

871 views

### Comparing two spreadsheets and returning similarities

The challenge I am presented with is this:
I have two spreadsheets where I need to compare one column of data from each spreadsheet.
How do I do the comparison and have the same numbers from both ...

**30**

votes

**3**answers

165k views

### Comparing two strings in Excel?

I need to compare two strings
in excel and determine if they
are equal, the strings are in adjacent
cells. For example, given:
apple apple
water water
pear carrot
apple water
dog dog
...

**1**

vote

**3**answers

3k views

### How can I compare columns in Excel?

If I have two columns of data with 10000 cells in each, and only three of the rows are not identical in both columns, how can I locate the different ones (without comparing each pair of cells)?

**3**

votes

**3**answers

5k views

### How to use WinMerge Excel plugin?

I know this works, because of this question - How do I compare two Excel documents?
I have installed Newest WinMerge and http://freemind.s57.xrea.com/xdocdiffPlugin/en/index.html newest plugin(I ...

**1**

vote

**3**answers

7k views

### How do I assign a number value to a non-numerical value in Excel

I have some survey responses with values like "VU" for "Very Unlikely" and "S" for Sometimes. Each survey response occupies a cell. For each cell containing a survey response, I want to fill another ...

**1**

vote

**1**answer

667 views

### Compare between Excel worksheets

All my product's SKU and prices are in an Excel document in different columns (Sheet1). In the same spreadsheet, but on another worksheet (Sheet2), I have distributor data with product SKU and prices. ...

**0**

votes

**1**answer

702 views

### Excel similar or comparison between two sheets and color row

I would like to compare two sheets (sheet1 and sheet2), and color a compleet row in sheet2 when for example 1 or more the same numbers are found in sheet1,
I came this far but then everything gets ...

**1**

vote

**4**answers

2k views

### Comparing two Excel Sheets in same XLS Document? [duplicate]

Possible Duplicate:
Compare between Excel worksheets
The title actually explains it all.
I would like to be able to compare two Excel Sheets in one Excel document.
Comparing two different ...

**76**

votes

**12**answers

247k views

### How do I compare two Excel documents? [closed]

The compare function in Word 2007 is very handy -- is there a similar capability in Excel 2007? I can't seem to find it...
The documents I'm trying to compare are essentially two versions of the same ...