here i have 2 sheets where Sheet 1 consists of top 5 products in a State that are in trending as per sales (State wise top 5)
|Product id||Product name ||Store code||Net Sales|
Sheet 2 consists of Store wise top 5 products as per sales (Store wise top 5)
|Product id||Product name||Store code||Net Sales|
In Sheet 3 i would like to compare Sheet 1 product id's And Sheet 2 Product id's and i want to display the Product id's list which are not Present sheet 2
(Store wise top 5 Products) but present in sheet 1 (State wise top 5 Products)
SHEET 3 (Desired Output)
Any help here would be really appreciated.
You may want to do a Left Join your [Sheet 1] table to your [Sheet 2] one --
using the join condition ON [Sheet 1].[Product Id] = [Sheet 2].[Product Id] --
then filter the rows where ISNULL( [Sheet 2].[Product Id] ) results in True.
Hope it could help.