Search : in
By :

Compare 4 columns in separate spreadsheet

fishbonez, on Sep 10, 2009 1:32:00 am BST 
 Report this message to moderators

Hello,
i would like to ask if anyone knows how to compare 2 columns in sheet 1 with another 2 columns in sheet 2 using "match"functions? Total 4 columns i will have to compare

Configuration: Windows 2000 Internet Explorer 6.0

Best answers for « Compare 4 columns in separate spreadsheet » in :
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Excel - Comparing columns and returning value ShowExcel - Comparing columns and returning value Issue Solution Note Issue I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A B C D ...
Burn an ISO image on two DVD of 4.7 Gb ShowBurn an ISO image on two DVD of 4.7 Gb Issue If you have an iso file or any type of files larger than 4.7GB and you want to burn it onto two DVD-ROM 4.7 GB Solution It can be done by creating an archive with 7zip and separate it into 2...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - Worksheets ShowThe Concept of a Worksheet Spreadsheets display data and formulas in a table form (lines and columns) called a worksheet. A worksheet is made of lines (numbered with numbers) and of columns (numbered with letters). The intersection of a line and a...
Spreadsheet - Text Operators ShowConcatenation Operator Spreadsheets generally use an oeprator, called a concatenation operator , that allows two text values to be added together. The concatenation operator, written as &, is used as follows: In the above example, the cell...
Ask your question Reply
They need your help