Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare cells of different external documents
I'm using Excel 2003.
I have a book1.xls in C:/folder1/ end book2.xls in C:/folder2. I wish to compare a indicated range of cells of book2 with book1 and report which is greater in a new excel file, book3.xls, without open book1.xls and book2.xls. Can anyone help me, please? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare cells of different external documents
In Book3, use a formula like:
=IF('C:\Folder1\[Book1.xls]Sheet1'!$A$1'C:\Folder2\[Book2.xls]Sheet2'!$A$1,"Book1 is greater", IF('C:\Folder1\[Book1.xls]Sheet1'!$A$1<'C:\Folder2\[Book2.xls]Sheet2'!$A$1,"Book2 is greater", "They are the same")) HTH, Bernie MS Excel MVP "VC++User" wrote in message ... I'm using Excel 2003. I have a book1.xls in C:/folder1/ end book2.xls in C:/folder2. I wish to compare a indicated range of cells of book2 with book1 and report which is greater in a new excel file, book3.xls, without open book1.xls and book2.xls. Can anyone help me, please? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
How do I compare two simular excel documents | Excel Worksheet Functions | |||
How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
Compare data - one cell to multiple cells | Excel Discussion (Misc queries) |