johnboy_001
New Member
- Joined
- Jun 26, 2014
- Messages
- 1
Hello All,
I'm trying to create an excel formula that takes the current PC system date, compares it with a list (4 years worth) of events matched with time/date and produces the most frequent event for the PC system date. A macro button would be used to trigger the formula
Example: PC System time: January 20th, 2012 12pm
Per list, 5 events happened on January 20th - 3 at 1pm, 2 at 7pm,
of those 5 events, majority were Class Echo.
End result: 1pm- Class Echo
Background: The purpose of this is to create a
event "prediction" to help achieve better spatial distribution, a good reference would be a 911 or police system that uses emergency call data and predicts where the next emergency will happen.
Any help or advice would be much appreciated. </press>
I'm trying to create an excel formula that takes the current PC system date, compares it with a list (4 years worth) of events matched with time/date and produces the most frequent event for the PC system date. A macro button would be used to trigger the formula
Example: PC System time: January 20th, 2012 12pm
Per list, 5 events happened on January 20th - 3 at 1pm, 2 at 7pm,
of those 5 events, majority were Class Echo.
End result: 1pm- Class Echo
Background: The purpose of this is to create a

Any help or advice would be much appreciated. </press>