-1
votes
0answers
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
2answers
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
2answers
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
1answer
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
2answers
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
2answers
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
3answers
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
3answers
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
3answers
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
3answers
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
1answer
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
1answer
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
4answers
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
12answers
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 ...