I have a dataset that looks a bit like this:
<tbody>
</tbody>
The record count can vary by customer. I'm looking to average the 3rd column's numbers, for up to the last 3 rows, by customer.
I have a separate list of unique customer ID's and I've been experimenting with AVERAGEIFS, Offset, etc., but can't seem to get the logic correct.
Could I kindly ask for an experts view on this and for any recommendations on a solution?
Many thanks!!
G
Cust A | 1/1/18 | 345 |
Cust A | 2/1/18 | 634 |
Cust A | 3/1/18 | 567 |
Cust B | 11/1/18 | 1209 |
Cust B | 12/1/18 | 1340 |
Cust B | 1/1/18 | 1500 |
Cust B | 2/1/18 | 1654 |
Cust B | 3/1/18 | 1567 |
Cust C | 2/1/18 | 423 |
Cust C | 3/1/18 | 450 |
Cust D | 3/1/18 | 1690 |
<tbody>
</tbody>
The record count can vary by customer. I'm looking to average the 3rd column's numbers, for up to the last 3 rows, by customer.
I have a separate list of unique customer ID's and I've been experimenting with AVERAGEIFS, Offset, etc., but can't seem to get the logic correct.
Could I kindly ask for an experts view on this and for any recommendations on a solution?
Many thanks!!
G