2
I have a table like so;
Component | Time
1 | 2014-03-13 13:52:12
1 | 2013-05-20 12:20:20
2 | 2014-03-13 13:53:43
etc., etc.
There can be x times for a single component. i.e. Component 1 has 2 times, Component 2 has 1 time, Component 3 might have 5 times.
I can used the Group function to group by component, what I really want though, is to just have the most recent time for each component. Not sure if there's a function to do something like this? Or I'll need to make something myself?
Pivot tables are incredible powerful tools that simplify data presentation. They're very much worth learning how use. – JaredT – 2016-05-09T01:35:52.197
A little more fiddly than I was hoping, but it is what I was after. I really appreciate the screenshots too. Thanks. – Trent – 2014-03-13T07:36:37.553