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

F

Feroz90

Board Regular
Joined
Apr 25, 2019
Messages
52
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
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
like this?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]Day[/td][td=bgcolor:#5B9BD5]Amt1[/td][td=bgcolor:#5B9BD5]Amt2[/td][td=bgcolor:#5B9BD5]Amt3[/td][td][/td][td=bgcolor:#70AD47]Day[/td][td=bgcolor:#70AD47]Amt1[/td][td=bgcolor:#70AD47]Amt2[/td][td=bgcolor:#70AD47]Amt3[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Monday[/td][td=bgcolor:#DDEBF7]
1000​
[/td][td=bgcolor:#DDEBF7]
2000​
[/td][td=bgcolor:#DDEBF7]
500​
[/td][td][/td][td=bgcolor:#E2EFDA]Monday[/td][td=bgcolor:#E2EFDA]
7000​
[/td][td=bgcolor:#E2EFDA]
14000​
[/td][td=bgcolor:#E2EFDA]
3000​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Monday[/td][td]
1000​
[/td][td]
2000​
[/td][td]
500​
[/td][td][/td][td]Tuesday[/td][td]
20300​
[/td][td]
7700​
[/td][td]
4000​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Monday[/td][td=bgcolor:#DDEBF7]
1000​
[/td][td=bgcolor:#DDEBF7]
2000​
[/td][td=bgcolor:#DDEBF7]
500​
[/td][td][/td][td=bgcolor:#E2EFDA]Wednesday[/td][td=bgcolor:#E2EFDA]
9000​
[/td][td=bgcolor:#E2EFDA]
15000​
[/td][td=bgcolor:#E2EFDA]
4000​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Monday[/td][td]
1000​
[/td][td]
2000​
[/td][td]
500​
[/td][td][/td][td]Thurday[/td][td]
11250​
[/td][td]
13750​
[/td][td]
5000​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Monday[/td][td=bgcolor:#DDEBF7]
1000​
[/td][td=bgcolor:#DDEBF7]
2000​
[/td][td=bgcolor:#DDEBF7]
500​
[/td][td][/td][td=bgcolor:#E2EFDA]Friday[/td][td=bgcolor:#E2EFDA]
59150​
[/td][td=bgcolor:#E2EFDA]
10850​
[/td][td=bgcolor:#E2EFDA]
10000​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Monday[/td][td]
1000​
[/td][td]
2000​
[/td][td]
250​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Monday[/td][td=bgcolor:#DDEBF7]
1000​
[/td][td=bgcolor:#DDEBF7]
2000​
[/td][td=bgcolor:#DDEBF7]
250​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Tuesday[/td][td]
2900​
[/td][td]
1100​
[/td][td]
750​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Tuesday[/td][td=bgcolor:#DDEBF7]
2900​
[/td][td=bgcolor:#DDEBF7]
1100​
[/td][td=bgcolor:#DDEBF7]
750​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Tuesday[/td][td]
2900​
[/td][td]
1100​
[/td][td]
600​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Tuesday[/td][td=bgcolor:#DDEBF7]
2900​
[/td][td=bgcolor:#DDEBF7]
1100​
[/td][td=bgcolor:#DDEBF7]
500​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Tuesday[/td][td]
2900​
[/td][td]
1100​
[/td][td]
500​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Tuesday[/td][td=bgcolor:#DDEBF7]
2900​
[/td][td=bgcolor:#DDEBF7]
1100​
[/td][td=bgcolor:#DDEBF7]
450​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Tuesday[/td][td]
2900​
[/td][td]
1100​
[/td][td]
450​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Wednesday[/td][td=bgcolor:#DDEBF7]
1500​
[/td][td=bgcolor:#DDEBF7]
2500​
[/td][td=bgcolor:#DDEBF7]
750​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Wednesday[/td][td]
1500​
[/td][td]
2500​
[/td][td]
750​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Wednesday[/td][td=bgcolor:#DDEBF7]
1500​
[/td][td=bgcolor:#DDEBF7]
2500​
[/td][td=bgcolor:#DDEBF7]
1000​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Wednesday[/td][td]
1500​
[/td][td]
2500​
[/td][td]
1000​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Wednesday[/td][td=bgcolor:#DDEBF7]
1500​
[/td][td=bgcolor:#DDEBF7]
2500​
[/td][td=bgcolor:#DDEBF7]
250​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Wednesday[/td][td]
1500​
[/td][td]
2500​
[/td][td]
250​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Thurday[/td][td=bgcolor:#DDEBF7]
2250​
[/td][td=bgcolor:#DDEBF7]
2750​
[/td][td=bgcolor:#DDEBF7]
1000​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Thurday[/td][td]
2250​
[/td][td]
2750​
[/td][td]
750​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Thurday[/td][td=bgcolor:#DDEBF7]
2250​
[/td][td=bgcolor:#DDEBF7]
2750​
[/td][td=bgcolor:#DDEBF7]
250​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Thurday[/td][td]
2250​
[/td][td]
2750​
[/td][td]
2000​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Thurday[/td][td=bgcolor:#DDEBF7]
2250​
[/td][td=bgcolor:#DDEBF7]
2750​
[/td][td=bgcolor:#DDEBF7]
1000​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Friday[/td][td]
8450​
[/td][td]
1550​
[/td][td]
450​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Friday[/td][td=bgcolor:#DDEBF7]
8450​
[/td][td=bgcolor:#DDEBF7]
1550​
[/td][td=bgcolor:#DDEBF7]
550​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Friday[/td][td]
8450​
[/td][td]
1550​
[/td][td]
2000​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Friday[/td][td=bgcolor:#DDEBF7]
8450​
[/td][td=bgcolor:#DDEBF7]
1550​
[/td][td=bgcolor:#DDEBF7]
3000​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Friday[/td][td]
8450​
[/td][td]
1550​
[/td][td]
1000​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Friday[/td][td=bgcolor:#DDEBF7]
8450​
[/td][td=bgcolor:#DDEBF7]
1550​
[/td][td=bgcolor:#DDEBF7]
1000​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Friday[/td][td]
8450​
[/td][td]
1550​
[/td][td]
2000​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]

or like this:

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]Day[/td][td=bgcolor:#70AD47]Amt1[/td][td=bgcolor:#70AD47]Amt2[/td][td=bgcolor:#70AD47]Amt3[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Monday[/td][td=bgcolor:#E2EFDA]
1000​
[/td][td=bgcolor:#E2EFDA]
2000​
[/td][td=bgcolor:#E2EFDA]
500​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Monday[/td][td]
1000​
[/td][td]
2000​
[/td][td]
250​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Tuesday[/td][td=bgcolor:#E2EFDA]
2900​
[/td][td=bgcolor:#E2EFDA]
1100​
[/td][td=bgcolor:#E2EFDA]
750​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Tuesday[/td][td]
2900​
[/td][td]
1100​
[/td][td]
600​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Tuesday[/td][td=bgcolor:#E2EFDA]
2900​
[/td][td=bgcolor:#E2EFDA]
1100​
[/td][td=bgcolor:#E2EFDA]
500​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Tuesday[/td][td]
2900​
[/td][td]
1100​
[/td][td]
450​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Wednesday[/td][td=bgcolor:#E2EFDA]
1500​
[/td][td=bgcolor:#E2EFDA]
2500​
[/td][td=bgcolor:#E2EFDA]
750​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Wednesday[/td][td]
1500​
[/td][td]
2500​
[/td][td]
1000​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Wednesday[/td][td=bgcolor:#E2EFDA]
1500​
[/td][td=bgcolor:#E2EFDA]
2500​
[/td][td=bgcolor:#E2EFDA]
250​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Thurday[/td][td]
2250​
[/td][td]
2750​
[/td][td]
1000​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Thurday[/td][td=bgcolor:#E2EFDA]
2250​
[/td][td=bgcolor:#E2EFDA]
2750​
[/td][td=bgcolor:#E2EFDA]
750​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Thurday[/td][td]
2250​
[/td][td]
2750​
[/td][td]
250​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Thurday[/td][td=bgcolor:#E2EFDA]
2250​
[/td][td=bgcolor:#E2EFDA]
2750​
[/td][td=bgcolor:#E2EFDA]
2000​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Friday[/td][td]
8450​
[/td][td]
1550​
[/td][td]
450​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Friday[/td][td=bgcolor:#E2EFDA]
8450​
[/td][td=bgcolor:#E2EFDA]
1550​
[/td][td=bgcolor:#E2EFDA]
550​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Friday[/td][td]
8450​
[/td][td]
1550​
[/td][td]
2000​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Friday[/td][td=bgcolor:#E2EFDA]
8450​
[/td][td=bgcolor:#E2EFDA]
1550​
[/td][td=bgcolor:#E2EFDA]
3000​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Friday[/td][td]
8450​
[/td][td]
1550​
[/td][td]
1000​
[/td][/tr]
[/table]

if not show example of expected result
 
Last edited:
Upvote 0
Or potentially this?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Monday[/TD]
[TD]1000[/TD]
[TD]2000[/TD]
[TD]3000[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Tuesday[/TD]
[TD]2900[/TD]
[TD]1100[/TD]
[TD]4000[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Wednesday[/TD]
[TD]1500[/TD]
[TD]2500[/TD]
[TD]4000[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Thurday[/TD]
[TD]2250[/TD]
[TD]2750[/TD]
[TD]5000[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Friday[/TD]
[TD]8450[/TD]
[TD]1550[/TD]
[TD]10000[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Hi All,

What I need should be like, If we calculate First 4 values in 3rd column, we get 2000, the next 3 values we will get 1000, same as that you can see for other days too, please assist how to do that.

Thanks
 
Upvote 0
Hey,

Can you manually write up a table of what you expect Monday to look like? I don't understand the criteria if I'm honest.
 
Upvote 0
Hi,

If you can see the above example, I need to sum the Amt 3 column to match Amt 1 & Amt 2 Column, lets assume, the first 4 rows (500,500,500,500) totals and gives 2000 which matches with Amt 2 of Monday, the next 3 rows (500,250,250) totals and gives 1000 which matches with Amt 1 of Monday, the same way every days will match either of the column total.

Please let me know if you do not understand, since I dont know how to insert the excel table, I had to explain like this.

Thanks
 
Upvote 0
Hi All,

This is best I can do,

[TABLE="width: 542"]
<colgroup><col><col span="4"><col></colgroup><tbody>[TR]
[TD]Days[/TD]
[TD]Amt 1[/TD]
[TD]Amt 2[/TD]
[TD]Amt 3[/TD]
[TD]Total[/TD]
[TD]Example[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]1000[/TD]
[TD]2000[/TD]
[TD]500[/TD]
[TD]2000[/TD]
[TD]500 + 500 + 500 + 500[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]1000[/TD]
[TD]2000[/TD]
[TD]500[/TD]
[TD]2000[/TD]
[TD]500 + 500 + 500 + 500[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]1000[/TD]
[TD]2000[/TD]
[TD]500[/TD]
[TD]2000[/TD]
[TD]500 + 500 + 500 + 500[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]1000[/TD]
[TD]2000[/TD]
[TD]500[/TD]
[TD]2000[/TD]
[TD]500 + 500 + 500 + 500[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]1000[/TD]
[TD]2000[/TD]
[TD]500[/TD]
[TD]1000[/TD]
[TD]500 + 250 + 250[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]1000[/TD]
[TD]2000[/TD]
[TD]250[/TD]
[TD]1000[/TD]
[TD]500 + 250 + 250[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]1000[/TD]
[TD]2000[/TD]
[TD]250[/TD]
[TD]1000[/TD]
[TD]500 + 250 + 250[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD]2900[/TD]
[TD]1100[/TD]
[TD]750[/TD]
[TD]2900[/TD]
[TD]750 + 750 + 500 + 450 +450[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD]2900[/TD]
[TD]1100[/TD]
[TD]750[/TD]
[TD]2900[/TD]
[TD]750 + 750 + 500 + 450 +450[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD]2900[/TD]
[TD]1100[/TD]
[TD]600[/TD]
[TD]1100[/TD]
[TD]600 + 500[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD]2900[/TD]
[TD]1100[/TD]
[TD]500[/TD]
[TD]1100[/TD]
[TD]600 + 500[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD]2900[/TD]
[TD]1100[/TD]
[TD]500[/TD]
[TD]2900[/TD]
[TD]750 + 750 + 500 + 450 +450[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD]2900[/TD]
[TD]1100[/TD]
[TD]450[/TD]
[TD]2900[/TD]
[TD]750 + 750 + 500 + 450 +450[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD]2900[/TD]
[TD]1100[/TD]
[TD]450[/TD]
[TD]2900[/TD]
[TD]750 + 750 + 500 + 450 +450[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD]1500[/TD]
[TD]2500[/TD]
[TD]750[/TD]
[TD]1500[/TD]
[TD]750 + 750[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD]1500[/TD]
[TD]2500[/TD]
[TD]750[/TD]
[TD]1500[/TD]
[TD]750 + 750[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD]1500[/TD]
[TD]2500[/TD]
[TD]1000[/TD]
[TD]2500[/TD]
[TD]1000 + 1000 + 250 +250[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD]1500[/TD]
[TD]2500[/TD]
[TD]1000[/TD]
[TD]2500[/TD]
[TD]1000 + 1000 + 250 +250[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD]1500[/TD]
[TD]2500[/TD]
[TD]250[/TD]
[TD]2500[/TD]
[TD]1000 + 1000 + 250 +250[/TD]
[/TR]
[TR]
[TD]Wednesday[/TD]
[TD]1500[/TD]
[TD]2500[/TD]
[TD]250[/TD]
[TD]2500[/TD]
[TD]1000 + 1000 + 250 +250[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Thursday[/TD]
[TD]2250[/TD]
[TD]2750[/TD]
[TD]1000[/TD]
[TD]2250[/TD]
[TD]1000 + 250 +1000[/TD]
[/TR]
[TR]
[TD]Thursday[/TD]
[TD]2250[/TD]
[TD]2750[/TD]
[TD]750[/TD]
[TD]2750[/TD]
[TD]750 + 2000[/TD]
[/TR]
[TR]
[TD]Thursday[/TD]
[TD]2250[/TD]
[TD]2750[/TD]
[TD]250[/TD]
[TD]2250[/TD]
[TD]1000 + 250 +1000[/TD]
[/TR]
[TR]
[TD]Thursday[/TD]
[TD]2250[/TD]
[TD]2750[/TD]
[TD]2000[/TD]
[TD]2750[/TD]
[TD]750 + 2000[/TD]
[/TR]
[TR]
[TD]Thursday[/TD]
[TD]2250[/TD]
[TD]2750[/TD]
[TD]1000[/TD]
[TD]2250[/TD]
[TD]1000 + 250 +1000[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD]8450[/TD]
[TD]1550[/TD]
[TD]450[/TD]
[TD]8450[/TD]
[TD]450 + 2000 + 3000 + 1000 + 2000[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD]8450[/TD]
[TD]1550[/TD]
[TD]550[/TD]
[TD]1550[/TD]
[TD]550 + 1000[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD]8450[/TD]
[TD]1550[/TD]
[TD]2000[/TD]
[TD]8450[/TD]
[TD]450 + 2000 + 3000 + 1000 + 2000[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD]8450[/TD]
[TD]1550[/TD]
[TD]3000[/TD]
[TD]8450[/TD]
[TD]450 + 2000 + 3000 + 1000 + 2000[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD]8450[/TD]
[TD]1550[/TD]
[TD]1000[/TD]
[TD]1550[/TD]
[TD]550 + 1000[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD]8450[/TD]
[TD]1550[/TD]
[TD]1000[/TD]
[TD]8450[/TD]
[TD]450 + 2000 + 3000 + 1000 + 2000[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD]8450[/TD]
[TD]1550[/TD]
[TD]2000[/TD]
[TD]8450[/TD]
[TD]450 + 2000 + 3000 + 1000 + 2000[/TD]
[/TR]
</tbody>[/TABLE]

Please check
 
Upvote 0
I give up, I lost logic in the first two steps for each day :(

maybe try Solver?

have a nice day
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Replace formula with zero when populate Right mark for two sheets
Replies
3
Views
379
awoohaw
awoohaw
F
  • Question Question
VBA Code for creating a formula for adding specific values (=IF(A2:A10)=B2,B2,C2))
2
Replies
17
Views
2K
Feroz90
F
C
  • Solved
Create Function that Calculates a Value Relative to Original Price and Also Constructs a Price Ladder
2
Replies
10
Views
1K
NdNoviceHlp
NdNoviceHlp
H
  • Solved
autofill for 11,200 rows based on matching between two sheets with another
Replies
8
Views
466
Hasson
H
A
  • Solved
show data for each sheet in listbox and merge based on combobox and optionbutton
Replies
6
Views
626
abdelfattah
A

Forum statistics

Threads
1,224,823
Messages
6,181,171
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top