Comparing two excel date columns and creating new sheet

Hi ,

Good Evening!

I want to know the way how to compare two excel Start Time columns and if Start Time was same copy only Start Time rows data into new sheet (Result).

this case can be understood as fetch all rows of a group and the grouping key is the Start Time Column

Find starter Help here:
FindDupsUniquesFirstFromGroup_By1Col.xaml (8.0 KB)

XAML is showcasing 3 cases - the stDupplicatesOnly is your case

You can start with processing start time on string level, maybe in a next round a parsing into datetime is more to prefer


Thank You So Much! It’s very helpful for me.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.