Hi all!
I have A TON of SQL data, and I've been racking my brain to figure out how to make this work. I need to identify the phone numbers who call in within certain time increments, and then figure out who the previous employee was who took the first call. Both pieces of information are available in the raw data. What I've been finding are formulas IF the data falls within certain date/time cell counts (referencing B1:B11 for example)- which isn't helpful. I have hundreds of thousands of rows of data and one day could use 100k rows while another day could use 20k.

Essentially, I have:

(Column A) Date/Time (Column B) Employee # (Column C) Customer Phone Number
01/01/2019 12:00:00 ................ 123456.......................(800)1234567

I've tried a pivot table, but it pulls so much information that doesn't give me my desired outcome. What I'm hoping to achieve is a couple extra columns at the end of my existing sheet so I can pivot that.

Future state:

Column A:Date/Time ..Column B:Employee # ..Column C:Customer Phone Number ..Column D:Same Day Repeat (Y/N=1/0) ..Column E:Original Agent (Pull previous employee #)
01/01/2019 12:00:00 ................ 123456.......................(800)1234567................................1............................................................123459

Future state metrics would include same-day repeats, 2 day repeats, and 2 week repeats. Any ideas?