Hi, if i have hundreds of lines all out of order that are set up like the first table; is there a way to sum the data by trips? A trip being consecutive days.
<tbody>
</tbody>
Results with formulas in red highlighted cells
<tbody>
</tbody>
Thanks for any help!
Acct# | Date | Cost |
3005 | 10/24/18 | 50 |
3005 | 10/25/18 | 100 |
3038 | 9/1/18 | 25 |
3038 | 9/2/18 | 50 |
3005 | 11/13/18 | 25 |
3005 | 11/14/18 | 50 |
3038 | 10/1/18 | 50 |
3038 | 10/2/18 | 75 |
<tbody>
</tbody>
Results with formulas in red highlighted cells
Acct# | Trip 1 | Trip 2 | Trip 3 |
3005 | 150 | 75 | |
3038 | 75 | 125 |
<tbody>
</tbody>
Thanks for any help!