See attached excel file 'SampleData'
My query is how would I go about using the 'Filter Tool' to filter records on the latest date in Column 'C' for each individual ID Column 'A' automatically.
For an example of what I mean after I had applied the filter, see attachment 'Results'
I am running Excel 2010.
Any assistance is appreciated.