Comparing two excel date columns and creating new sheet

[kaungset]

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).

[ppr (Peter Preuss)]

@kaungset
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

[kaungset]

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