If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
compare worksheets data
I have two work sheets, version 1 and version 2. I am trying to identify
what changed. The data is as follows: Invoice # Item # Amount 11111 aaaaa 1.00 11111 bbbbb 2.00 22222 aaaaa .50 22222 bbbbb .75 33333 bbbbb 1.00 44444 ccccc 1.00 Can anyone help??? |
#2
|
|||
|
|||
find data that changed Wrote: I have two work sheets, version 1 and version 2. I am trying to identify what changed. The data is as follows: Invoice # Item # Amount 11111 aaaaa 1.00 11111 bbbbb 2.00 22222 aaaaa .50 22222 bbbbb .75 33333 bbbbb 1.00 44444 ccccc 1.00 Can anyone help??? Add a third worksheet and use the following formula =IF(Sheet1!A1=Sheet2!A1,"No Change","Changed") you need to change sheet1/sheet2 in the formula to matcch the names of your worksheets If invoice # is cell A1, then start from there, then drag the formula down and across as far as required All the cells with Changed in them are the ones you are looking for -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=393504 |
#3
|
|||
|
|||
On Fri, 5 Aug 2005 17:19:02 -0700, "find data that changed" find data
that wrote: I have two work sheets, version 1 and version 2. I am trying to identify what changed. The data is as follows: Invoice # Item # Amount 11111 aaaaa 1.00 11111 bbbbb 2.00 22222 aaaaa .50 22222 bbbbb .75 33333 bbbbb 1.00 44444 ccccc 1.00 Can anyone help??? There's an add-in called Compare.xls that you may find useful. See: http://www.cpearson.com/excel/whatsnew.htm --------------------------------------------------------- Hank Scorpio scorpionet who hates spam is at iprimus.com.au (You know what to do.) * Please keep all replies in this Newsgroup. Thanks! * |
#4
|
|||
|
|||
That worked great Paul...Thanks!!!
"Paul Sheppard" wrote: find data that changed Wrote: I have two work sheets, version 1 and version 2. I am trying to identify what changed. The data is as follows: Invoice # Item # Amount 11111 aaaaa 1.00 11111 bbbbb 2.00 22222 aaaaa .50 22222 bbbbb .75 33333 bbbbb 1.00 44444 ccccc 1.00 Can anyone help??? Add a third worksheet and use the following formula =IF(Sheet1!A1=Sheet2!A1,"No Change","Changed") you need to change sheet1/sheet2 in the formula to matcch the names of your worksheets If invoice # is cell A1, then start from there, then drag the formula down and across as far as required All the cells with Changed in them are the ones you are looking for -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=393504 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Compare data on 2 separate worksheets. | Wayne | Worksheet Functions | 2 | July 6th, 2005 10:11 PM |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Compare data in two databases | Max W. | General Discussion | 3 | September 29th, 2004 08:12 AM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |