Excel Remove Duplicates based on time condition

0 votes
A 3 month rolling time condition is the basis for my search for duplicates to be eliminated from a 250,000-row Excel sheet.

We have a lot of user IDs and the dates on which they visited, however many of these visits are spread out over long periods of time (often more than a year), and many of them occur on the same day or a few days.

An example is the greatest method to illustrate what I want to do. So if they came to visit on January 1, January 1, January 3, January 8, February 4, June 5, December 1, and December 2, I would want to use the first date of January 1, June 4, and December 1.

If they came on January 1, January 2, January 3, February 8, or April 9, then on August 1 or September 1, I would like January 1 and August 8.

As a result, we want to book the initial date, then observe how frequently they return within 3 months of each visit, and if they go more than 3 months without coming back, book the first date they have after they do. After three months, they occasionally return four or five more times, and the data may cover several years.

Is there a way I can accomplish this?
Nov 2 in Others by Kithuzzz
• 20,660 points
23 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Others

0 votes
0 answers

get unique distinct items based on a condition and a date condition

hi could you help me sorry my ...READ MORE

Nov 23, 2021 in Others by adolpo
• 120 points
40 views
0 votes
1 answer

datatable remove column on export to pdf and excel

When we are using jquery datatable for ...READ MORE

answered Feb 17 in Others by gaurav
• 22,040 points
1,822 views
0 votes
1 answer
0 votes
1 answer

Excel Conditional Formatting based on Adjacent Cell Value

The row number used in the formula ...READ MORE

answered Oct 10 in Others by narikkadan
• 37,660 points
152 views
0 votes
1 answer

Sort Excel worksheets based on name, which is a date

Sorting sheets of a workbook are rather ...READ MORE

answered Oct 17 in Others by narikkadan
• 37,660 points
43 views
0 votes
1 answer

Repeated excel rows based on a cell with multiple values

You can use this query: let ...READ MORE

answered Oct 20 in Others by narikkadan
• 37,660 points
37 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
449 views
0 votes
1 answer

How to duplicate IDs with Hive QL / Impala / Python

Based on your example, supposing id2 always ...READ MORE

answered Oct 1, 2018 in Python by Priyaj
• 58,100 points
359 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
394 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,365 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP