So what i need to do is sum the values in the Units and amount columns if :
- the person is the same
- "x" starting number of characters is same in the desc column (ex. one__ or three____)
- the Cur being "U"
Then i need to insert a new BOLDED row underneath each change in colour in the rows with the sums of the units and amount columns
<tbody>
</tbody>
so after it would kind of look like it looks for the brown rows for all of the colours
<tbody>
</tbody>
- the person is the same
- "x" starting number of characters is same in the desc column (ex. one__ or three____)
- the Cur being "U"
Then i need to insert a new BOLDED row underneath each change in colour in the rows with the sums of the units and amount columns
group | Person | Desc | Cur | xx | Units | xx | amount |
111 | abc | one - 1 | U | xx | 531 | xx | 35146 |
111 | abc | one - 23 | U | xx | 785 | xx | 584684 |
111 | abc | one - 4 | U | xx | 9 | xx | 4125 |
222 | def | one - 1 | U | xx | -65 | xx | 452 |
222 | def | one - 23 | U | xx | 45 | xx | -52 |
222 | def | one - 4 | U | xx | 41 | xx | 852 |
333 | hij | three- 9 | U | xx | -546 | xx | 452 |
333 | hij | three - 4 | U | xx | 254 | xx | 45 |
444 | klm | two - 9 | U | xx | -2 | xx | 2263 |
444 | klm | two - 4 | U | xx | 45 | xx | -35 |
444 | klm | two- 6 | C | xx | 345 | xx | 4587 |
444 | klm | two - 8 | C | xx | 35 | xx | 753 |
<tbody>
</tbody>
so after it would kind of look like it looks for the brown rows for all of the colours
group | Person | Desc | Cur | xx | Units | xx | amount |
111 | abc | one - 1 | U | xx | 531 | xx | 35146 |
111 | abc | one - 23 | U | xx | 785 | xx | 584684 |
111 | abc | one - 4 | U | xx | 9 | xx | 4125 |
111 | abc | 1325 | 623955 | ||||
222 | def | one - 1 | U | xx | -65 | xx | 452 |
222 | def | one - 23 | U | xx | 45 | xx | 52 |
222 | def | one - 4 | U | xx | 41 | xx | 852 |
333 | hij | three- 9 | U | xx | -546 | xx | 452 |
333 | hij | three - 4 | U | xx | 254 | xx | 45 |
444 | klm | two - 9 | U | xx | -2 | xx | 2263 |
444 | klm | two - 4 | U | xx | 45 | xx | 35 |
444 | klm | two- 6 | C | xx | 345 | xx | 4587 |
444 | klm | two - 8 | C | xx | 35 | xx | 753 |
<tbody>
</tbody>