Please Help!! Looking for differences between data sets

[ShirlF]

[TABLE="width: 1365"]
<COLGROUP><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1938" width=53><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" width=59><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 174pt; mso-width-source: userset; mso-width-alt: 8484" width=232><COL style="WIDTH: 103pt; mso-width-source: userset; mso-width-alt: 5010" width=137><COL style="WIDTH: 166pt; mso-width-source: userset; mso-width-alt: 8082" width=221><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 8pt; mso-width-source: userset; mso-width-alt: 402" span=2 width=11><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2377" width=65><COL style="WIDTH: 15pt; mso-width-source: userset; mso-width-alt: 731" width=20><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 203pt; mso-width-source: userset; mso-width-alt: 9874" width=270><COL style="WIDTH: 48pt" span=6 width=64><TBODY>[TR]
[TD="class: xl68, width: 112, bgcolor: transparent, colspan: 2"]Hi There.[/TD]
[TD="width: 85, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 232, bgcolor: transparent"][/TD]
[TD="width: 137, bgcolor: transparent"][/TD]
[TD="width: 221, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 11, bgcolor: transparent"][/TD]
[TD="width: 11, bgcolor: transparent"][/TD]
[TD="width: 79, bgcolor: transparent"][/TD]
[TD="width: 65, bgcolor: transparent"][/TD]
[TD="width: 20, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 270, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent, colspan: 28"]I am analysing a sales order book on a week to week basis. The Sales order reference remains the same but order values can change daily based on shipped/cancelled and amended orders.
Can anybody suggest the best way to reconcile these differences please? I have used an if statement but it has still taken me four hours to find the differences <!-- google_ad_section_end -->[/TD]
[/TR]
</TBODY>[/TABLE]
[TABLE="width: 1820"]
<TBODY>[TR]
[TD="colspan: 2"]</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 28"]</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL span=2><COL><COL><COL><COL><COL><COL span=6></COLGROUP>[/TABLE]

 

[mole999]

if you can bear it
paste one in new sheet 1 new book, the other in sheet 2, on three then compare with =IF(Sheet1!A1<>Sheet2!A1,"1","")

drag to compare the cells to see where there are differences

 

[ShirlF]

Hey, thankyou so much for replying. Yes I tried a similar thing using =IF(AND(A3=D3)*AND(B3=E3),"true") by copying the Sales order ref and value only over from both weeks. Here I was telling Exel to show me the order numbers that were both exactly the same in both weeks so no movement. It worked a treat but still then took me a few hours to analyse the differences which were order amendments and good movements. I am new to Excel too so I know there must be an easier way to then ldentify the differences :-/