Home » Forums » Open Source Learning Center » Question and Answer

Best way to look for differences in similar data sets

Submitted by ShirleyF on 13 October, 2015 - 13:19

Hi There.

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 in excel please?

‹ How to Ignore Duplicate find and match Formula help ›
»

Example

Submitted by Max F. on 13 October, 2015 - 14:21.

Hi Shirley,

There are a few ways this can be done, and it will be hard to give you an answer that will work for you without seeing an example of what you are looking at.

Could you provide a screenshot of and example?

Thanks,

-Max

»