• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Comparison

Mohammed Ashraf

New Member
Hello Experts,

Requesting you to please help me in the below question.

I am trying to compare the employee data between SAP & the Success Factors. I downloaded the report from SAP & SF. Apparently the is misaligned.

Position title of an employee is different from SAP, which is maintained in Success Factors.

Column A has position number & column B has position title, this data is from Success Factors. Column C has position number & D has position title & the data is from SAP.

Is there a way i can compare the position title with the position number using any formula?

Appreciate your swift response on this.

Cheers!
Ashraf
 
1st of all, welcome.
2ndly, if you upload a sample file (fake data, but real structure) we can give workable advise. Since you are new, please have a read of the site rules.
 
Hello
Copy and cleave in cell G4 and drag to the other cells of the column.
The formula is matrix.

=IFERROR(INDEX($A$4:$A$32,MATCH(D4&E4,$A$4:$A$32&$B$4:$B$32,0)),"different")
 
Thank you guys it was very helpful. The formula works. However i need your further support.

I want to know the below as well,

1) Position number which are excess or not matching from the success factors
2) Exact number of the position title which doesnt match & how to segregate them?

Appreciate your help guys.

Cheers!
 

Attachments

  • For Chandoo 2.xlsx
    280.1 KB · Views: 6
Converting this to a table (or better two tables) would allow structured references to be used in place of whole column references. On my computer this led to order-of-magnitude faster calculation.
 
Here is an example. The formulas adjust dynamically to match the actual data. You would need to understand 'structured references' but, provided you do, the formulas are readable.
 

Attachments

  • List compare (PB).xlsx
    296.5 KB · Views: 10
Back
Top