check duplicate row and keep only the last one

Hi guys,

Hi have a sheet with an automatic import (using Data Uploader)

For some reasons, sometimes I have two times the same row datas collected from my data sources.

How can I use a formula to check if I have duplicate row and if I have duplicate row, only "keep" (or check a box for the row) the last import (I already use an automatic workflow to record a date, when a row is added)

I already use a formula like this to mark a column with a "1" when there is a duplicate row :

=IF([Start Date]@row = "", 0, IF(COUNTIF([Start Date]:[Start Date], [Start Date]@row) > 1, 1))

So I would like to have a "1" only when row is a duplicated one AND only for the row with column "ImportDate" containing the more recent date

Thanks

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try this...

=IF([Start Date]@row = "", 0, IF(AND([Added Date]@row = MAX(COLLECT([Added Date]:[Added Date], [Start Date]:[Start Date], [Start Date]@row)), COUNTIF([Start Date]:[Start Date], [Start Date]@row) > 1), 1))

Louis Depraetere

Thanks

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.