Link to home
Start Free TrialLog in
Avatar of itsmevic
itsmevicFlag for United States of America

asked on

This Probably Isn't Technically Possible But will Ask Anyway (Excel Macro 2010, VBSCRPT - Pulling Patterns)

Hey there Experts!

     I'm curious if a macro, add-in or third party type software can be invoked in a spreadsheet that will detect time patterns.  

For example, I'm looking at IP's, there are date time stamps associated with each IP .  My pivot table is broken down by IP address and under that the dates and times.  What I"m looking for is patterns....

Let's say under IP 1.1.1.1 I have a date/time stamp of 08/24/2012 13:52 and then 3 minutres later another 13:55 and 3 minutes later 13:58 and then 2 minutes later 13:60 and then it repeats...trying to target behavior like that.  Is there anything remotely out there that can assist me in identifying this behavior or is the human eye going to be the only work-around in this scenerio?

Example of my Pivot Table data:

0.0.0.0 <--IP Address
8/24/2012 13:52  <---Dates and Tims
8/24/2012 13:53
8/24/2012 13:53
8/24/2012 13:53
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:56
8/24/2012 13:57
8/24/2012 13:58
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 13:59
8/24/2012 14:00
8/24/2012 14:00
8/24/2012 14:00
1.1.1.1
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:01
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
8/24/2012 14:02
ASKER CERTIFIED SOLUTION
Avatar of PaulHend
PaulHend
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial