Forum Discussion
Checking data in two rows, and if the same then take the latest time and date form another row
I have a question I am looking for a formula of VBA for the following comparisation. I want to filter or mark only the latest date and time in column G, from which data in column C a...
You could create a PivotTable and move the date field into 'values' and then set field to 'max'. Then it's a matter of adding the desired fields in rows or columns to fill out the detail you need.
Attached is a sample.