Hi
I appreciate this may be a bit vague!
I have two stock sheets/lists which are separate excel documents – one for January 18 and one for February 18.
On Jan 18’s the balance is £70,722.69 and on Feb 18’s it is £65,081.78. So the stock balance has gone down.
I am trying to find a formula that will compare the two documents and identify what stock was on Jan 18’s list that has reduced or no longer exists in Feb 18’s list.
There are over 400 rows so it’s not easy to spot by just glancing and rows may have even been deleted.
If you need more info let me know!
Thanks
Bookmarks