Hi,
I'm sure excel can do this but not sure where to start.
Please refer to the table below. Basically, I need a formula in the 'qtr' column which will reset to 'Q1' any time the value of the reference number in the 'ref' column changes.
Any help much appreciated! Thanks, Cal.
<tbody>
Ref...