Hi everyone,
I have a simple worksheet that records the number of maintenance visits my team has performed over time. Each row is a single visit instance. I am trying to figure out how I can write formulas that will show:
- The distinct count of "TripID" per "Project"
- The latest/last "Site Visit Actual Date" by "Project"
- The count of days since the last "Site Visit Actual Date" by "Project"
Can anyone guide me on any of these? Sample of the data is linked below.
Many thanks,
Alan
The data sample is very small with only one trip and two projects. Assuming that your real data is much larger I would recommend that you start by formatting the data as a structured Excel table. That'll make formula writing and maintenance much easier.
Provided you are on a modern Excel version the formula's added to your file maybe all you need. If not, please come back here with some more data and the expected results.
Hi Riny,
Many thanks for getting back to me so quickly. I took your advice and made a table, I was able to generate a couple of pivot tables and calculated formulas to get the detail I was after - thanks for the inspiration!
Alan