Hi everyone,
Below I'm attaching initial Data and the desired result. The logic to apply is If the Employee Name subsequent rows are equal (Ex: APPLEBEE, CAROL=APPLEBEE, CAROL), and REPORT column subsequent rows are FM08-TSTL410A, and NEW Number subsequent rows are equal (Ex:0001=0001), and then the Difference Variance column contains a zero and subsequent row number is different to zero.
I really appreciate the help you can provide.
Solved! Go to Solution.
User | Count |
---|---|
107 | |
85 | |
76 | |
54 | |
40 |