Hi Excel Gurus,
How to Reconcile two values splitted in multiple rows in same column
In the below example you may see, for each day, we have same amount in two columns but these amount are splitted in third column, how can we match these. Any suggestions.
Example:
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
Thanks
How to Reconcile two values splitted in multiple rows in same column
In the below example you may see, for each day, we have same amount in two columns but these amount are splitted in third column, how can we match these. Any suggestions.
Example:
Monday | 1000 | 2000 | 500 |
Monday | 1000 | 2000 | 500 |
Monday | 1000 | 2000 | 500 |
Monday | 1000 | 2000 | 500 |
Monday | 1000 | 2000 | 500 |
Monday | 1000 | 2000 | 250 |
Monday | 1000 | 2000 | 250 |
Tuesday | 2900 | 1100 | 750 |
Tuesday | 2900 | 1100 | 750 |
Tuesday | 2900 | 1100 | 600 |
Tuesday | 2900 | 1100 | 500 |
Tuesday | 2900 | 1100 | 500 |
Tuesday | 2900 | 1100 | 450 |
Tuesday | 2900 | 1100 | 450 |
Wednesday | 1500 | 2500 | 750 |
Wednesday | 1500 | 2500 | 750 |
Wednesday | 1500 | 2500 | 1000 |
Wednesday | 1500 | 2500 | 1000 |
Wednesday | 1500 | 2500 | 250 |
Wednesday | 1500 | 2500 | 250 |
Thurday | 2250 | 2750 | 1000 |
Thurday | 2250 | 2750 | 750 |
Thurday | 2250 | 2750 | 250 |
Thurday | 2250 | 2750 | 2000 |
Thurday | 2250 | 2750 | 1000 |
Friday | 8450 | 1550 | 450 |
Friday | 8450 | 1550 | 550 |
Friday | 8450 | 1550 | 2000 |
Friday | 8450 | 1550 | 3000 |
Friday | 8450 | 1550 | 1000 |
Friday | 8450 | 1550 | 1000 |
Friday | 8450 | 1550 | 2000 |
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
Thanks