Compare Table.

Question

One person enter data in tally software ledger name and amount. At the same time another person enter same data tally software. Ultimately Both are different output. Now both data export to Excel. Find the mistakes? I have seen only values are unique. Something is missing found.

First

Find the missing values.

Find the duplicate value not possible. Same value are repeated. Any solution.

Answer 1

Hi,

In the file that you have shared, clearly show the result you are expecting.

Answer 2

Compare products

This contain two tables in one sheet.

Please try it

Now using the formula

=VLOOKUP( "*"& A1&"*",B:B, 1,0)

Single product working but bulk not working.

Answer 3

Hi SHARBIN DAVIS

It is difficult to visualize and/or reproduce your scenario and requirement with the current information,  your worksheet is too complex to give you a solution without having access to your file.

Kindly suggest preparing and uploading a sample file to Onedrive, Dropbox, etc ... and share the link here.

Please first,

a)  Remove any personal/sensitive data.

b) Keep the headers, table structure, and formulas as they actually are.

c) ZIP the file if contains macros, pictures, shapes, or other objects.

d) Provide more details of your scenario and goals.  Also, post the results in the way you expect.

This will help us to give you a prompt and right solution.

If you need help with how to upload the file please, click the link below

https://support.office.com/en-us/article/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07

You may also follow the instructions in this video

https://www.youtube.com/watch?v=NnXsE0SNuCc&t=14s

Regards

Jeovany