Automating Duplicate Check

[JulieBunavicz]

Hi,

Currently I am identifying duplicate rows based via a manual process/function. Example below. Is it possible to automate something like this, like “auto duplicate flagging”?

—Dupe Check based on minutes in a day

=IF(C2=C1,(D2-D1)*1440,"First")

-- Dupe Check based on < 30 minutes

=IF(E2<>"First",IF(E2<30,"Dup",""),"")

Let me know if you have any questions.

Kind regards,

Julie Bunavicz

 

[BigBeachBananas]

Hi,

Currently I am identifying duplicate rows based via a manual process/function. Example below. Is it possible to automate something like this, like “auto duplicate flagging”?

—Dupe Check based on minutes in a day

=IF(C2=C1,(D2-D1)*1440,"First")

-- Dupe Check based on < 30 minutes

=IF(E2<>"First",IF(E2<30,"Dup",""),"")

Let me know if you have any questions.

Kind regards,

Julie Bunavicz

It would be more helpful if you could share a sample of your data along with desired outcome.

 

[JulieBunavicz]

Hi Joe I’m sorry I cannot share data due to privacy concerns. The closest I can get to that is the formulas above. No worries it doesn’t have to be solved right away

 

[Joe4]

Hi Joe I’m sorry I cannot share data due to privacy concerns. The closest I can get to that is the formulas above. No worries it doesn’t have to be solved right away

Make up some dummy data and post that.
This kind of thing is very dependent on what you data structure, what your data looks like, and your expected results.
So I think you will find you get more people responding if you can show us some examples.

 

[JulieBunavicz]

julie_bunavicz

community.fabric.microsoft.com

Website

 

[JulieBunavicz]

Power Automate helped with part of the solution