i need a macro to be created in excel to first filter the data by latest or the last date in the end time column and delete rest of the data,then delete the ##### frm the result time of ( end time - start time) and then found the duplicates and paste in sheet 2 .
also i need to delete in dupes the one which has the higher time ---- this code i need separte.
Based on your data, the max end time is 17:16:02 and that is the only row with that value. Are you sure you want to delete all rows that are not equal to that value. Also what ##### ? I dont see any. In Excel ##### is basicially showing that column width is too small to show you the number, Also what do you mean by duplication.Is is some column where the values cannot be duplication or you are saying the whole row needs to be identical