• 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
 

GraH - Guido

Well-Known Member
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.
 

Luiz Carlos

New Member
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")
 

Mohammed Ashraf

New Member
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

Peter Bartholomew

Well-Known Member
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.
 
Top