Hello Friends,
I am new here, require help to compare the values of breakup cells vs consolidated cells. Example as below.
I need to compare D1(employee code) which is having some consolidated total amount in E1. Now I have breakup of that in A1 which is picked up from another working sheet (same employee code as D1) with breakup figures in B1 to B3. Same with D2 & E2. Now there is a figure mismatch between employee code D2 having values in E2 against sum of B4+B5+B6. I need a formula where there is a mismatch in sum against particular employee code, that employee code should highlighted with some colour, so I can compare those two columns & do necessary rectification. This is nothing but comparison between columns having breakup & consolidated amount.
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:204; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}--></style>
<tbody>
</tbody>
Thanks in advance.
I am new here, require help to compare the values of breakup cells vs consolidated cells. Example as below.
I need to compare D1(employee code) which is having some consolidated total amount in E1. Now I have breakup of that in A1 which is picked up from another working sheet (same employee code as D1) with breakup figures in B1 to B3. Same with D2 & E2. Now there is a figure mismatch between employee code D2 having values in E2 against sum of B4+B5+B6. I need a formula where there is a mismatch in sum against particular employee code, that employee code should highlighted with some colour, so I can compare those two columns & do necessary rectification. This is nothing but comparison between columns having breakup & consolidated amount.
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.5in; mso-footer-margin:.5in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; mso-font-charset:204; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}--></style>
A | B | C | D | E |
1234567 | 5840 | 1234567 | 92572 | |
1234567 | 85985 | 2123456 | 21300 | |
1234567 | 747 | |||
2123456 | 4568 | |||
2123456 | 7893 | |||
2123456 | 8894 |
<tbody>
</tbody>
Thanks in advance.