COMPARING DATA

JERRY89
4StarLounger
Posts: 483
Joined: 21 Feb 2016, 02:52

COMPARING DATA

Post by JERRY89 »

Dear All,

i am having a sheet of data where i need to do data comparison between two sheet , so i need to copy out the Batch No that is not available to the sheet, usually i will have to compare data with more than 5 thousand item, in this sample attached i provide the short version.
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 72573
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: COMPARING DATA

Post by HansV »

If you have Microsoft 365 or Office 2021, here is a simple solution using UNIQUE and FILTER.

TESTING DATA.xlsx
You do not have the required permissions to view the files attached to this post.
Regards,
Hans

JERRY89
4StarLounger
Posts: 483
Joined: 21 Feb 2016, 02:52

Re: COMPARING DATA

Post by JERRY89 »

Hi Hans,

Mine version is excel 2016, so is there a method for this case?? :hairout:

User avatar
HansV
Administrator
Posts: 72573
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: COMPARING DATA

Post by HansV »

Here you go. Recalculating will be slow.

TESTING DATA.xlsx
You do not have the required permissions to view the files attached to this post.
Regards,
Hans

p45cal
StarLounger
Posts: 76
Joined: 11 Jun 2012, 20:37

Re: COMPARING DATA

Post by p45cal »

In Excel 2016 you will have Power Query (aka Get & Transform Data on the Data tab of the ribbon).
In the attached, update the source tables with new data. On the Main Data sheet are two new tables (queries) which need refreshing; either by clicking on Refresh All in the Queries & Connections section of the Data tab of the ribbon, or by right-clicking a table and choosing Refresh to update it.
You do not have the required permissions to view the files attached to this post.