How to Reconcile two values splitted in multiple rows in same column

[Feroz90]

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:

[TABLE="width: 272"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]Monday[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD="align: right"]2900[/TD]
[TD="align: right"]1100[/TD]
[TD="align: right"]750[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD="align: right"]2900[/TD]
[TD="align: right"]1100[/TD]
[TD="align: right"]750[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD="align: right"]2900[/TD]
[TD="align: right"]1100[/TD]
[TD="align: right"]600[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD="align: right"]2900[/TD]
[TD="align: right"]1100[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD="align: right"]2900[/TD]
[TD="align: right"]1100[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD="align: right"]2900[/TD]
[TD="align: right"]1100[/TD]
[TD="align: right"]450[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD="align: right"]2900[/TD]
[TD="align: right"]1100[/TD]
[TD="align: right"]450[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD="align: right"]1500[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]750[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD="align: right"]1500[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]750[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD="align: right"]1500[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD="align: right"]1500[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD="align: right"]1500[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD="align: right"]1500[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Thurday[/TD]
[TD="align: right"]2250[/TD]
[TD="align: right"]2750[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]Thurday[/TD]
[TD="align: right"]2250[/TD]
[TD="align: right"]2750[/TD]
[TD="align: right"]750[/TD]
[/TR]
[TR]
[TD]Thurday[/TD]
[TD="align: right"]2250[/TD]
[TD="align: right"]2750[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Thurday[/TD]
[TD="align: right"]2250[/TD]
[TD="align: right"]2750[/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD]Thurday[/TD]
[TD="align: right"]2250[/TD]
[TD="align: right"]2750[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD="align: right"]8450[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]450[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD="align: right"]8450[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]550[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD="align: right"]8450[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD="align: right"]8450[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]3000[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD="align: right"]8450[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD="align: right"]8450[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD="align: right"]8450[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]2000[/TD]
[/TR]
</tbody>[/TABLE]

Thanks

 

[Feroz90]

Thank you.

Can anyone give a try

 

[Feroz90]

Hi Friends,

Does anyone have any suggestions.

Thanks