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:

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

 

[Feroz90]

Thank you.

Can anyone give a try

 

[Feroz90]

Hi Friends,

Does anyone have any suggestions.

Thanks