Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare information from two spreadsheets or excel sheets
Don't know if any one can help, I am trying to find an easy way to compare
data from one spread sheet to another on Excel 2000. Every week I create a spreadsheet and need to find out if any further items added on it. example old spreadsheet would be called Andrews 19.04.2010 with 3 sheets 4 columns on each. The new one would be Andrews 26.04.2010 same set up again but possibley new items on the Andrews 26.04.2010 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare information from two spreadsheets or excel sheets
Add a fifth corresponding column on the NEW sheet and insert the following
formula in the first cell: =SUMPRODUCT((OldSheet!A:A=A1)*(OldSheet!B:B=B1)*(O ldSheet!C:C=C1)*(OldSheet!D:D=D1)) Copy it down. This will give u the no. of times the an identical entry is occurring in the OldSheet. The cells with result 0 will be the ones that are new. -- Thanx & Best Regards, Faraz! "EJA" wrote: Don't know if any one can help, I am trying to find an easy way to compare data from one spread sheet to another on Excel 2000. Every week I create a spreadsheet and need to find out if any further items added on it. example old spreadsheet would be called Andrews 19.04.2010 with 3 sheets 4 columns on each. The new one would be Andrews 26.04.2010 same set up again but possibley new items on the Andrews 26.04.2010 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - How to compare two spreadsheets | Excel Discussion (Misc queries) | |||
how can I compare two excel spreadsheets? | Excel Worksheet Functions | |||
how do i compare two excel spreadsheets to indicate differences | Excel Worksheet Functions | |||
How do I compare 2 excel spreadsheets? | Excel Discussion (Misc queries) | |||
Is there a way to compare 2 spreadsheets with Excel? | Excel Discussion (Misc queries) |