Recent content by Number101

The idea would be first call gets marked as 1 and second call gets marked as 1 and third call gets marked 0.

Mayby I explaned it wrong. I have a large table (100000 + entries) which have call records. How can I count the instances of re-occurrence within a set number of hours? My original data is: 1st column: call Date (date and time format) 2nd column: Caller ID; 3rd column person who answered...

So I'm attaching the pictures of the original data and what I like to achieve.

Yes I hope to end up with a query, My original data is in excel it looks like this: Call timeClient_number2017.03.10888732712017.03.16888732712017.03.16888732712017.03.17888732712017.04.04888732712017.04.14888732712017.04.19888732712017.04.19888732712017.04.1988873271 I have imported this data...

Hi I'm new to all vba stuff, so I need help creating a code for clients, that have called more than once in 24 hours. Basicly I have data with client number and call date, The problem that I can't solve is, if client called after more than 24 hours I need to start new cycle of repeated calls in...