comparing two excel files

[Gopinath_iyer]

Hi

I have two excel files EMP (has duplicates) and Master (unique rows) but number of columns are not same in both the files.

Both data has emp number as common field and I want to find the list of employees present in EMP and not present in Master and vise versa.

Can this be achieved?

regards,

Gopi

[Shaurya · Accepted solution]

Hi @Gopinath_iyer,

You can use the following formulas:

Distinct Emp Count = DISTINCTCOUNT(Emp[ID])

Emp not in Master = [Distinct Emp Count] - CALCULATE(Emp[Distinct Emp Count],FILTER(Emp,Emp[ID] IN VALUES(Master[ID])))

Result:

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Graphical Comparison