What I am trying to do is create a tool to generate stat data using VB. I have so many records that using formulas and filters is killing me.
Here is a sample Table
Col A - Unique ID
Col B - Date 1
Col C - Date 2
I want to run a function that returns a stat (ex: average) for all records where Date 2 falls within a timeframe.
Example: Calculate Average of (Date 2 - Date 1) for records that -2 is in the month of October.
Any Help here?
Here is a sample Table
Col A - Unique ID
Col B - Date 1
Col C - Date 2
I want to run a function that returns a stat (ex: average) for all records where Date 2 falls within a timeframe.
Example: Calculate Average of (Date 2 - Date 1) for records that -2 is in the month of October.
Any Help here?