Report statistics from table of data

[Bryce C.]

Hi,

I am trying to build a macro that will return specific data from a table. The table is divided into half hour time brackets and I need to be able to pull 1 stat from specfic time brackets. For example, I am trying to pull MM_Transfer_Caller stats from 07:00:00-07:30:00 and again from 07:30:00-08:00:00 from the table below. The "Time of Day", "Event Name" and "Event Codes" are all in seperate coumns.

Any thoughts on how to complete this type of macro?

Thank you very much!

Time of Day Event Name Event Count
06:00:00 - 06:30:00
DLI_Renew 6
DLI_Renew_By_Phone 2
DLI_Replace_Lost_Stolen 2
FAQ_Answer 6
FOL_Office_Address 3
FOL_Office_By_Zip 19
FOL_Office_Locator 19
FR_Main 5
FR_Transfer_Caller 1
FR_ZIPCode 1
II_CorrectPIN 1
II_HaveItems 1
II_HavePIN 1
II_Main 2
II_PINLookupSuccess 1
MM_Caller_Trouble 12
MM_Goodbye 10
MM_Hot_Topics 8
MM_Insurance_Inquiry 2
MM_Main 85
MM_Release_Of_Liability 1
MM_System_Error 7
MM_Transfer_Caller 40
MM_Vehicle_Info 6
MM_Vehicle_Registration 14
NT_HostDown 1
NT_Main 1
VRI_All_Other_Questions 1
VRI_Menu 6
VRI_Registration 1
VRI_Something_Else 2
VRI_Status_of_Registration 1
VRIR_Caller_Trouble 1
VRIR_CCConfirmed 1
VRIR_CheckEligibility 4
VRIR_CorrectRIN 5
VRIR_CustomTermination 4
VRIR_DCConfirmed 1
VRIR_DCExpDate 1
VRIR_EFTConfirmed 1
VRIR_EligibleStatus 4
VRIR_EnterAcctNum 1
VRIR_EnterCCNum 1
VRIR_EnterDebitCdNum 1
VRIR_EnterExpDate 1
VRIR_EnterRouteNum 1
VRIR_GetMatchingPlate 4
VRIR_HaveRenewalItems 9
VRIR_HaveRIN 6
VRIR_InsuranceCheckOK 4
VRIR_Last3DigitsOfPlate 5
VRIR_PayByCredit 2
VRIR_PayByDebit 1
VRIR_PayByPhoneSuccess 2
VRIR_PayInfoComplete 1
VRIR_PaymentRoutine 4
VRIR_PlayCostInfo 4
VRIR_RecordVerified 4
VRIR_RegistrationDueDate 4
VRIR_RenewRegistration 14
VRIR_RINAllDigits 6
VRIR_VehicleYear 4
VRIR_VRCount 4
SubTotal: 562
06:30:00 - 07:00:00
DL_EnterExpDate 3
DL_HaveDLNum 5
DL_HaveRenewalItems 5
DL_HaveRIN 3
DL_LicenseConfirmed 4
DL_Main 5
DL_Med_Disclosure 3
DL_Med_Info_OK 3
DL_MedorVision_OK 3
DL_OrganDonor 1
DL_PayByCredit 3
DL_PayByPhoneSucces 3
DL_PaymentRoutine 3
DL_PhoneNumber_YES 3
DL_RenewalCompleted 3
DL_Validated 3
DL_ValidateDL 3
DL_YOB 3
DLI_Check_Status 2
DLI_DUI 2
DLI_Menu 40
DLI_New_Resident 1
DLI_Renew 16
DLI_Renew_By_Phone 5
DLI_Replace_Lost_Stolen 8
FAQ_Answer 21
FOL_Office_Address 12
FOL_Office_By_Zip 31
FOL_Office_Locator 35
FR_Form_Ordered 1
FR_Main 11
FR_Transfer_Caller 1
FR_ZIPCode 4
II_CorrectPIN 10
II_CorrectVIN 1
II_CustomerTermination 6
II_HaveIDinformation 2
II_HaveItems 16
II_HavePIN 11
II_InsuranceNotFound 1
II_InsuranceWithFee 4
II_LicenseLookupSuccess 6
II_Main 20
II_PassengerVeh 1
II_PINLookupSuccess 9
II_PINNotFound 2
II_PINTagFail 2
II_PINTagSuccess 7
II_StdTag 1
II_StdTagSuccess 1
II_SuspendedWithFee 1
II_VINAllDigits 2
IS_ConfirmSuccess 1
IS_Main 2
IS_NAICNumSuccess 1
IS_PolicyNumSuccess 2
IS_VerifDateSuccess 1
MM_Caller_Trouble 19
MM_Goodbye 7
MM_Hot_Topics 19
MM_Insurance_Inquiry 20
MM_Main 191
MM_Non_Use 2
MM_System_Error 3
MM_Transfer_Caller 92
MM_Vehicle_Info 11
MM_Vehicle_Registration 28
NU_Main 2
RF_CCPaymentCompleted 3
RF_DCConfirmed 3
RF_DebitCard 4
RF_EnterDCExpDate 3
RF_EnterDCNum 4
RF_Main 4
VRI_All_Other_Questions 1
VRI_Menu 11
SubTotal: 1116
07:00:00 - 07:30:00
AS_Appt_Confirm 22
AS_BTWDLNum 12
AS_BTWDOB 7
AS_BTWDrivingTestAuto 12
AS_BTWDrivingTestCycle 1
II_VINAllDigits 3
IS_ConfirmSuccess 1
IS_Main 5
IS_NAICNumSuccess 4
IS_PolicyNumSuccess 5
IS_VerifDateSuccess 2
MM_Caller_Trouble 69
MM_Goodbye 24
MM_Hot_Topics 32
MM_Insurance_Inquiry 20
MM_Main 516
MM_Non_Use 2
MM_Release_Of_Liability 1
MM_System_Error 16
MM_Transfer_Caller 266
MM_Vehicle_Info 37
MM_Vehicle_Registration 79
NT_HostDown 1
NT_Main 1
NU_CustomTermination 1
NU_Main 2
RF_CCPaymentCompleted 1
RF_DCConfirmed 1
RF_DebitCard 1
RF_EnterDCExpDate 1
RF_EnterDCNum 1
RF_Main 2
VRI_All_Other_Questions 2
VRI_Menu 37
VRI_Name_Addr_Chg 1
VRI_New_Resident 2
VRI_Registration 11
VRI_Replace_Stickers_Reg 3
VRI_Replace_Title_Plates 4
VRI_Sell_Vehicle 1
VRI_Smog 1
VRI_Something_Else 7
VRI_Status_of_Registration 2
VRIR_Caller_Trouble 18
VRIR_CCConfirmed 5
VRIR_CheckEligibility 15
VRIR_CorrectRIN 22
VRIR_CustomTermination 35
VRIR_DCConfirmed 6
VRIR_DCExpDate 6
VRIR_EFTConfirmed 3
VRIR_EligibleStatus 14
VRIR_EnterAcctNum 3
VRIR_EnterCCNum 5
VRIR_EnterDebitCdNum 6
VRIR_EnterExpDate 5
VRIR_EnterRouteNum 3
VRIR_GetMatchingPlate 15
VRIR_HaveRenewalItems 42
VRIR_HaveRIN 26
VRIR_InsuranceCheckOK 13
VRIR_Last3DigitsOfPlate 18
VRIR_NonStdKeypadEntry 1
VRIR_NonStdTag 3
VRIR_NonStdTagSuccess 1
VRIR_PayByCredit 5
VRIR_PayByDebit 7
VRIR_PayByPhoneSuccess 6
VRIR_PayInfoComplete 3
VRIR_PaymentRoutine 13
VRIR_PlayCostInfo 13
VRIR_RecordVerified 13
VRIR_RegistrationDueDate 15
VRIR_RenewRegistration 79
VRIR_RINAllDigits 21
VRIR_RINWithChar 4
VRIR_VehicleYear 17
VRIR_VRCount 13
SubTotal: 2866
07:30:00 - 08:00:00
AS_Appt_Confirm 54
AS_BTWDLNum 36
AS_BTWDOB 13
AS_BTWDrivingTestAuto 35
AS_BTWDrivingTestCycle 1
AS_BTWDrivingTestType 40
AS_DTMF_Char_Std 6
AS_OVDLVRApptNum 19
AS_OVDriverLicense 114
AS_OVVehicleRegApptNum 57
AS_OVVisitType 209
AS_PhoneNumber 185
AS_Schedule_Appointment 253
AS_Schedule_BTW_Test 47
AS_SetAppointment 112
DL_CCConfirmed 3
DL_CharConfirmed 1
DL_CheckEligibility 8
DL_Contribution 1
DL_CorrectRIN 8
DL_CorrectSSNO 4
DL_CorrectYOB 5
DL_CreditCard 3
DL_CustomTermination 2
DL_DLNum 14
DL_DLR_Disclosure 3
DL_DTMF_Char_Std 2
DL_EligibleStatus 7
DL_EnterCCNum 3
DL_EnterExpDate 3
DL_HaveDLNum 10
DL_HaveRenewalItems 14
DL_HaveRIN 9
DL_LicenseConfirmed 9
DL_Main 15
DL_Med_Disclosure 3
DL_Med_Info_OK 4
DL_MedorVision_OK 4
DL_OrganDonor 1
DL_PayByCredit 3
DL_PayByPhoneSucces 3
DL_PaymentRoutine 3
DL_PhoneNumber_YES 4
DL_RenewalCompleted 3
DL_Validated 4
DL_ValidateDL 4
DL_YOB 7
DLI_Check_Status 28
DLI_Child_Support 1
DLI_DUI 11
DLI_Menu 245
DLI_Name_Addr_Chg 4
DLI_New_Resident 3
DLI_Renew 70
DLI_Renew_By_Phone 15
DLI_Renew_Schedule_Appt 15
DLI_Replace_Lost_Stolen 24
FAQ_Answer 114
FOL_Office_Address 38
FOL_Office_By_Zip 170
FOL_Office_Locator 197
FR_Form_Ordered 4
FR_Main 48
FR_Transfer_Caller 7
FR_ZIPCode 12
II_CorrectPIN 28
II_CorrectVIN 15
II_CustomerTermination 13
II_HaveIDinformation 19
II_HaveItems 56
II_HavePIN 28
II_InsuranceNotFound 2
II_InsuranceWithFee 2
II_LicenseLookupSuccess 11
II_Main 68
II_NonStdTag 3
II_OtherVeh 1
II_PassengerVeh 15
II_PINLookupSuccess 24
II_PINNotFound 4
II_PINTagSuccess 12
II_StdTag 12
II_StdTagSuccess 5
II_SuspendedNoFee 1
II_SuspendedWithFee 6
II_VINAllDigits 18
IS_ConfirmSuccess 4
IS_Main 6
IS_NAICNumSuccess 2
IS_PolicyNumSuccess 3
IS_VerifDateSuccess 3
MM_Caller_Trouble 182
MM_Goodbye 45
MM_Hot_Topics 48
MM_Insurance_Inquiry 68
MM_Main 1113
MM_Non_Use 4
MM_Release_Of_Liability 3
MM_System_Error 30
MM_Transfer_Caller 703
MM_Vehicle_Info 110
MM_Vehicle_Registration 165
NT_HostDown 3
NT_Main 3
NU_CustomTermination 1
NU_Main 4
RF_CCConfirmed 1
RF_CCPaymentCompleted 2
RF_CreditCard 1
RF_DCConfirmed 1
RF_DebitCard 2
RF_EnterCCExpDate 1
RF_EnterCCNum 1
RF_EnterDCExpDate 1
RF_EnterDCNum 1
RF_Main 4
VRI_All_Other_Questions 17
VRI_Buy_Vehicle 1
VRI_Disabled 2
VRI_Menu 110
VRI_Name_Addr_Chg 3
VRI_New_Resident 2
VRI_Registration 21
VRI_Replace_Stickers_Reg 7
VRI_Replace_Title_Plates 9
VRI_Smog 2
VRI_Something_Else 48
VRI_Status_of_Registration 13
VRI_Transfer_Vehicle 2
VRIR_Caller_Trouble 27
VRIR_CCConfirmed 8
VRIR_CheckEligibility 24
VRIR_CorrectRIN 40
VRIR_CustomTermination 57
VRIR_DCConfirmed 3
VRIR_DCExpDate 3
VRIR_EFTConfirmed 3
VRIR_EligibleStatus 22
VRIR_EnterAcctNum 3
VRIR_EnterCCNum 10
VRIR_EnterDebitCdNum 4
VRIR_EnterExpDate 8
VRIR_EnterRouteNum 6
VRIR_GetMatchingPlate 26
VRIR_HaveRenewalItems 89
VRIR_HaveRIN 55
VRIR_InsuranceCheckOK 19
VRIR_Last3DigitsOfPlate 39
VRIR_NonStdTag 2
VRIR_PayByCredit 11
VRIR_PayByDebit 4
VRIR_PayByPhoneSuccess 12
VRIR_PayInfoComplete 3
VRIR_PaymentRoutine 19
VRIR_PlayCostInfo 19
VRIR_RecordVerified 20
VRIR_RegistrationDueDate 26
VRIR_RenewRegistration 168
VRIR_RINAllDigits 44
VRIR_RINWithChar 11
VRIR_SmogCheckNO 5
VRIR_SmogCheckOK 4
VRIR_VehicleYear 35
VRIR_VRCount 20
SubTotal: 6298
08:00:00 - 08:30:00
AS_Appt_Confirm 122
AS_BTWDLNum 87
AS_BTWDOB 37
AS_BTWDrivingTestAuto 83
AS_BTWDrivingTestCycle 4
AS_BTWDrivingTestType 87
AS_DTMF_Char_Std 12
AS_OVDLVRApptNum 24
AS_OVDriverLicense 247
AS_OVVehicleRegApptNum 131
AS_OVVisitType 437
AS_PhoneNumber 412
AS_Schedule_Appointment 558
AS_Schedule_BTW_Test 95
AS_SetAppointment 251
DL_CCConfirmed 4
DL_CharConfirmed 5
DL_CheckEligibility 8
DL_CorrectRIN 8
DL_CorrectSSNO 7
DL_CorrectYOB 7
DL_CreditCard 5
DL_CustomTermination 1
DL_DLNum 19
DL_DLR_Disclosure 7
DL_EFT 1
DL_EligibleStatus 7
DL_EnterCCNum 5
DL_EnterExpDate 5
DL_EnterRouteNum 1
DL_HaveDLNum 12
DL_HaveRenewalItems 19
DL_HaveRIN 11
DL_LicenseConfirmed 11
DL_Main 22
DL_Med_Disclosure 7
DL_Med_Info_OK 7
DL_MedorVision_Issue 1
DL_MedorVision_OK 6
DL_PayByCredit 5
DL_PayByPhoneSucces 4
DL_PaymentRoutine 7
DL_PhoneNumber_NO 1
DL_PhoneNumber_YES 6
DL_RenewalCompleted 4
DL_Validated 7
DL_ValidateDL 7
DL_YOB 7
DLI_Accidents 3
DLI_Check_Status 91
DLI_Child_Support 2
DLI_DUI 18
DLI_Menu 616
DLI_Name_Addr_Chg 7
DLI_New_Resident 5
DLI_Renew 189
DLI_Renew_By_Phone 22
DLI_Renew_Schedule_Appt 42
DLI_Replace_Lost_Stolen 45
FAQ_Answer 217
FOL_Office_Address 69
FOL_Office_By_Zip 347
FOL_Office_Locator 386
FR_Form_Ordered 4
FR_Main 53
FR_Transfer_Caller 5
FR_ZIPCode 14
II_CommercialVeh 5
II_Confirmation 1
II_CorrectPIN 43
II_CorrectVIN 39
II_CustomerTermination 26
II_HaveIDinformation 45
II_HaveItems 91
II_HavePIN 45
II_InsuranceNotFound 1
II_InsuranceValid 1
II_InsuranceWithFee 3
II_LicenseLookupSuccess 15
II_Main 107
II_NonStdTag 6
II_NonStdTagSuccess 5
II_OtherVeh 5
II_PassengerVeh 28
II_PINLookupSuccess 29
II_PINNotFound 14
II_PINTagFail 1
II_PINTagSuccess 14
II_StdKeypadEntry 2
II_StdTag 25
II_StdTagSuccess 8
II_SuspendedWithFee 10
II_VINAllDigits 41
IS_ConfirmSuccess 2
IS_Main 7
IS_NAICKeypadEntry 1
IS_NAICNumSuccess 3
IS_PolicyNumSuccess 3
IS_VerifDateSuccess 2
MM_Caller_Trouble 241
MM_Goodbye 117
MM_Hot_Topics 34
MM_Insurance_Inquiry 107
MM_Main 3186
MM_Non_Use 9
MM_Release_Of_Liability 7
MM_System_Error 102
MM_Transfer_Caller 2766
MM_Vehicle_Info 202
MM_Vehicle_Registration 330
NT_HostDown 7
NT_Main 7
NU_CustomTermination 2
NU_Main 9
NU_Submit 1
RF_CCConfirmed 2
RF_CCPaymentCompleted 3
RF_CreditCard 3
RF_CustomTermination 2
RF_DCConfirmed 1
RF_DebitCard 3
RF_EnterCCExpDate 2
RF_EnterCCNum 3
RF_EnterDCExpDate 2
RF_EnterDCNum 3
RF_Main 9
VRI_All_Other_Questions 27
VRI_Buy_Vehicle 4
VRI_Disabled 2
VRI_Menu 202
VRI_Name_Addr_Chg 8
VRI_New_Resident 10
VRI_Registration 36
VRI_Replace_Stickers_Reg 9
VRI_Replace_Title_Plates 13
VRI_Sell_Vehicle 2
VRI_Smog 5
VRI_Something_Else 88
VRI_Status_of_Registration 20
VRI_Transfer_Vehicle 4
VRIR_Caller_Trouble 67
VRIR_CCConfirmed 10
VRIR_CheckEligibility 41
VRIR_CorrectRIN 67
VRIR_CustomTermination 149
VRIR_DCConfirmed 5
VRIR_DCExpDate 5
VRIR_EFTConfirmed 1
VRIR_EligibleStatus 32
VRIR_EnterAcctNum 1
VRIR_EnterCCNum 15
VRIR_EnterDebitCdNum 9
VRIR_EnterExpDate 12
VRIR_EnterRouteNum 2
VRIR_GetMatchingPlate 45
VRIR_HaveRenewalItems 148
VRIR_HaveRIN 86
VRIR_InsuranceCheckOK 28
VRIR_Last3DigitsOfPlate 53
VRIR_NonStdTag 9
VRIR_NonStdTagSuccess 3
VRIR_PayByCredit 15
VRIR_PayByDebit 9
VRIR_PayByPhoneSuccess 12
VRIR_PayInfoComplete 1
VRIR_PaymentRoutine 26
VRIR_PlayCostInfo 28
VRIR_RecordVerified 29
VRIR_RegistrationDueDate 45
VRIR_RenewRegistration 336
VRIR_RINAllDigits 73
VRIR_RINWithChar 16
VRIR_SmogCheckNO 5
VRIR_SmogCheckOK 4
VRIR_VehicleYear 50
VRIR_VRCount 29

[Richard Buttrey]

Hi, and welcome to the forumUnfortunately your post does not comply with Rule 1 of our Forum [/I]RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

I'll change it for you on this occasion as you are new here but please note for the future[/I]

You might find a Pivot Table will deliver what you want. Don't automatically think you need a macro.