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>
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...