Hi Guys,
I have about 600 rego numbers for which I need to figure out below.
1) Difference between minimum & maximum odo reading for unique rego numbers
2) Days between minimum & maximum odo reading for unique rego numbers
Below is an example of my data with 4 rego numbers
I thought Pivot table would work best with Min Max, but I can not figure out formula for the calculated field.
I tried =MAX('Odometer Reading')-MIN('Odometer Reading'), with Rego Number as my Row Label.
<tbody>
</tbody>
I have about 600 rego numbers for which I need to figure out below.
1) Difference between minimum & maximum odo reading for unique rego numbers
2) Days between minimum & maximum odo reading for unique rego numbers
Below is an example of my data with 4 rego numbers
I thought Pivot table would work best with Min Max, but I can not figure out formula for the calculated field.
I tried =MAX('Odometer Reading')-MIN('Odometer Reading'), with Rego Number as my Row Label.
<tbody> </tbody> |
<tbody>
</tbody>