I have an excel spreadsheet with three columns
A Time column
A Id Column
A value column
There is a row of data generated every second.
I would like some VBA code that will scan a time column for whole minutes and copy the time value, ID and value to new columns.
In the attached file the times will be minutes 1 to 10 on a full data set this would occur across 24 hours.