# Tagged Questions

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 ...
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 ...
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.
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 ...
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.
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")
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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)?
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...