bonjour les amis,
I've got two spreadsheets that i want to compare the data. The first sheet is our yearly inventory and the second sheet is our official inventory. I would like to prepare a forumula ( match or vlookup?) that compares the 2010 inventory to our official inventory and returns a list of the decrepencies (IE highlight the bikes on the global inventory that are not on the 2010 invnentory)
thanks brainiacs!
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
Hi,
I'm assuming you mean two workbooks and not two worksheets, and assuming the two books are laid out the same, in a spare column in the global inventory in row 1 enter
and copy down. Filter this column for #N/A and these are the discrepancies.
Please Login or Register to view this content.
HTH
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks