Spreadsheet: 156276d1337250000-count-if-formula-new_workbook-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | Box 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Based on Column F |  |  |  |  | Based on Column F
 |  |  |  |  |  |  |  |  |  | Date |  |  |  | Transaction |  |  |  |  | Transaction
Date | Start | Finish | Date & Time range from web | Cre/Deb | Description | £ | Balance |  |  | Date | Credit | Debit |  | Date |  | Credit | Debit |  | Who | Count | Credit | Debit
2012-05-08 00:00:00 | 23:10:00 | 2112-12-11 00:00:00 | 2012-05-08 23:10:00 | Debit | DirectP (xxx) Facility Fee, with ??? | -0.6 | -0.6 |  |  | 2012-05-08 00:00:00 | 2.97 | -0.8899999999999999 |  | DirectP |  | 0 | 0 |  | ??? 1 |  | #N/A | #N/A
2012-05-08 00:00:00 | 23:10:00 | 2112-12-11 00:00:00 | 2012-05-08 23:10:00 | Credit | DirectP (xxx) with ??? | 2 | 1.4 |  |  | 2012-05-09 00:00:00 | 153.04 | -7.6 |  | [NAME] |  | 0 | 0 |  | ??? 2 |  | #N/A | #N/A
2012-05-08 00:00:00 | 23:16:00 | 2021-09-05 00:00:00 | 2012-05-08 23:16:00 | Debit | DirectP (xxx) Facility Fee, with ??? | -0.29 | 1.11 |  |  | 2012-05-10 00:00:00 | 0 | -1.5 |  | 24 Hours subscription |  | 0 | 0 |  | ??? 3 |  | #N/A | #N/A
2012-05-08 00:00:00 | 23:16:00 | 2021-09-05 00:00:00 | 2012-05-08 23:16:00 | Credit | DirectP (xxx) with ??? | 0.97 | 2.08 |  |  | 2012-05-11 00:00:00 | 4.11 | -1.2 |  | [NAME] |  | 0 | 0 |  | ??? 4 |  | #N/A | #N/A
2012-05-09 00:00:00 | 00:08:00 | 2052-02-07 00:00:00 | 2012-05-09 00:08:00 | Debit | DirectP (xxx) Facility Fee, with ??? | -0.39 | 1.69 |  |  | 2012-05-12 00:00:00 | 0 | -1 |  |  |  |  |  |  | ??? 5
2012-05-09 00:00:00 | 00:08:00 | 2052-02-07 00:00:00 | 2012-05-09 00:08:00 | Credit | DirectP (xxx) with ??? | 1.28 | 2.98 |  |  | 2012-05-13 00:00:00 | 1 | 0 |  |  |  |  |  |  | ??? 6
2012-05-09 00:00:00 | 00:16:00 | 1930-06-02 00:00:00 | 2012-05-09 00:16:00 | Debit | DirectP (xxx) Facility Fee, with ??? | -0.17 | 2.81 |  |  |  |  |  |  |  |  |  |  |  | ??? 7
2012-05-09 00:00:00 | 00:16:00 | 1930-06-02 00:00:00 | 2012-05-09 00:16:00 | Credit | DirectP (xxx) with ??? | 0.57 | 3.37
2012-05-09 00:00:00 | 00:20:00 | 2143-05-14 00:00:00 | 2012-05-09 00:20:00 | Credit | 24 Hours subscription  xxxxxxxxxxxxxxxxxx, Expires xxxx | 0.5 | 3.87
2012-05-09 00:00:00 | 00:23:00 | 1960-11-02 00:00:00 | 2012-05-09 00:23:00 | Credit | 24 Hours subscription  xxxxxxxxxxxxxxxxxx, Expires xxxx | 0.5 | 4.37
2012-05-09 00:00:00 | 00:31:00 | 2112-12-11 00:00:00 | 2012-05-09 00:31:00 | Debit | DirectP (xxx) Facility Fee, with ??? | -0.34 | 4.03
2012-05-09 00:00:00 | 00:31:00 | 2112-12-11 00:00:00 | 2012-05-09 00:31:00 | Credit | DirectP (xxx) with ??? | 1.13 | 5.16
2012-05-09 00:00:00 | 00:47:00 | 2143-05-14 00:00:00 | 2012-05-09 00:47:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.61 | 4.55
2012-05-09 00:00:00 | 00:47:00 | 2143-05-14 00:00:00 | 2012-05-09 00:47:00 | Credit | [NAME] (xxx) with ??? | 12.12 | 16.67
2012-05-09 00:00:00 | 01:02:00 | 2052-02-07 00:00:00 | 2012-05-09 01:02:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.83 | 15.85 | Available for Transfer Now
2012-05-09 00:00:00 | 01:02:00 | 2052-02-07 00:00:00 | 2012-05-09 01:02:00 | Credit | [NAME] (xxx) with ??? | 16.52 | 32.37
2012-05-09 00:00:00 | 01:14:00 | 2143-05-14 00:00:00 | 2012-05-09 01:14:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.52 | 31.84 | Available for Transfer Now
2012-05-09 00:00:00 | 01:14:00 | 2143-05-14 00:00:00 | 2012-05-09 01:14:00 | Credit | [NAME] (xxx) with ??? | 10.47 | 42.31
2012-05-09 00:00:00 | 01:32:00 | 2143-05-14 00:00:00 | 2012-05-09 01:32:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.68 | 41.63 | Available for Transfer Now
2012-05-09 00:00:00 | 01:32:00 | 2143-05-14 00:00:00 | 2012-05-09 01:32:00 | Credit | [NAME] (xxx) with ??? | 13.67 | 55.3
2012-05-09 00:00:00 | 01:44:00 | 1960-11-02 00:00:00 | 2012-05-09 01:44:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.46 | 54.84 | Available for Transfer Now
2012-05-09 00:00:00 | 01:44:00 | 1960-11-02 00:00:00 | 2012-05-09 01:44:00 | Credit | [NAME] (xxx) with ??? | 9.27 | 64.11
2012-05-09 00:00:00 | 01:44:00 | 1960-11-02 00:00:00 | 2012-05-09 01:44:00 | Credit | [NAME] (xxx) Facility Fee, with ??? | 15 | 79.11 | Available for Transfer Now
2012-05-09 00:00:00 | 01:44:00 | 1960-11-02 00:00:00 | 2012-05-09 01:44:00 | Debit | [NAME] (xxx) with ??? | 0 | 79.11 | Available for Transfer Now
2012-05-09 00:00:00 | 01:49:00 | 2021-09-05 00:00:00 | 2012-05-09 01:49:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.25 | 78.86
2012-05-09 00:00:00 | 01:49:00 | 2021-09-05 00:00:00 | 2012-05-09 01:49:00 | Credit | [NAME] (xxx) with ??? | 5 | 83.86
2012-05-09 00:00:00 | 02:08:00 | 2143-05-14 00:00:00 | 2012-05-09 02:08:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -1 | 82.86 | Available for Transfer Now
2012-05-09 00:00:00 | 02:08:00 | 2143-05-14 00:00:00 | 2012-05-09 02:08:00 | Credit | [NAME] (xxx) with ??? | 19.99 | 102.85
2012-05-09 00:00:00 | 02:19:00 | 2112-12-11 00:00:00 | 2012-05-09 02:19:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.57 | 102.28 | Available for Transfer Now
2012-05-09 00:00:00 | 02:19:00 | 2112-12-11 00:00:00 | 2012-05-09 02:19:00 | Credit | [NAME] (xxx) with ??? | 11.41 | 113.69
2012-05-09 00:00:00 | 02:22:00 | 1930-06-02 00:00:00 | 2012-05-09 02:22:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.13 | 113.56 | Available for Transfer Now
2012-05-09 00:00:00 | 02:22:00 | 1930-06-02 00:00:00 | 2012-05-09 02:22:00 | Credit | [NAME] (xxx) with ??? | 2.53 | 116.09
2012-05-09 00:00:00 | 02:39:00 | 2082-07-10 00:00:00 | 2012-05-09 02:39:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.64 | 115.45
2012-05-09 00:00:00 | 02:39:00 | 2082-07-10 00:00:00 | 2012-05-09 02:39:00 | Credit | [NAME] (xxx) with ??? | 12.83 | 128.28
2012-05-09 00:00:00 | 02:43:00 | 2021-09-05 00:00:00 | 2012-05-09 02:43:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.01 | 128.27 | Available for Transfer Now
2012-05-09 00:00:00 | 02:43:00 | 2021-09-05 00:00:00 | 2012-05-09 02:43:00 | Credit | [NAME] (xxx) with ??? | 0.1 | 128.37
2012-05-09 00:00:00 | 02:44:00 | 2143-05-14 00:00:00 | 2012-05-09 02:44:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.1 | 128.28 | Available for Transfer Now
2012-05-09 00:00:00 | 02:44:00 | 2143-05-14 00:00:00 | 2012-05-09 02:44:00 | Credit | [NAME] (xxx) with ??? | 1.96 | 130.24
2012-05-09 00:00:00 | 02:47:00 | 1960-11-02 00:00:00 | 2012-05-09 02:47:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.01 | 130.23 | Available for Transfer Now
2012-05-09 00:00:00 | 02:47:00 | 1960-11-02 00:00:00 | 2012-05-09 02:47:00 | Credit | [NAME] (xxx) with ??? | 0.13 | 130.36
2012-05-09 00:00:00 | 02:49:00 | 1930-06-02 00:00:00 | 2012-05-09 02:49:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.03 | 130.33 | Available for Transfer Now
2012-05-09 00:00:00 | 02:49:00 | 1930-06-02 00:00:00 | 2012-05-09 02:49:00 | Credit | [NAME] (xxx) with ??? | 0.54 | 130.87
2012-05-09 00:00:00 | 02:57:00 | 2082-07-10 00:00:00 | 2012-05-09 02:57:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.02 | 130.85 | Available for Transfer Now
2012-05-09 00:00:00 | 02:57:00 | 2082-07-10 00:00:00 | 2012-05-09 02:57:00 | Credit | [NAME] (xxx) with ??? | 0.46 | 131.31
2012-05-09 00:00:00 | 03:19:00 | 2021-09-05 00:00:00 | 2012-05-09 03:19:00 | Credit | 24 Hours subscription  xxxxxxxxxxxxxxxxxx, Expires xxxx | 0.5 | 131.81 | Available for Transfer Now
2012-05-09 00:00:00 | 03:19:00 | 2021-09-05 00:00:00 | 2012-05-09 03:19:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.03 | 131.78 | Available for Transfer Now
2012-05-09 00:00:00 | 03:19:00 | 2021-09-05 00:00:00 | 2012-05-09 03:19:00 | Credit | [NAME] (xxx) with ??? | 0.63 | 132.41
2012-05-09 00:00:00 | 18:22:00 | 2112-12-11 00:00:00 | 2012-05-09 18:22:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.05 | 132.36 | Available for Transfer Now
2012-05-09 00:00:00 | 18:22:00 | 2112-12-11 00:00:00 | 2012-05-09 18:22:00 | Credit | [NAME] (xxx) with ??? | 0.9 | 133.26
2012-05-09 00:00:00 | 18:50:00 | 1960-11-02 00:00:00 | 2012-05-09 18:50:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.43 | 132.84 | Available for Transfer Now
2012-05-09 00:00:00 | 18:50:00 | 1960-11-02 00:00:00 | 2012-05-09 18:50:00 | Credit | [NAME] (xxx) with ??? | 8.52 | 141.36
2012-05-09 00:00:00 | 21:28:00 | 2021-09-05 00:00:00 | 2012-05-09 21:28:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | 0 | 141.35 | Available for Transfer Now
2012-05-09 00:00:00 | 21:28:00 | 2021-09-05 00:00:00 | 2012-05-09 21:28:00 | Credit | [NAME] (xxx) with ??? | 0.08 | 141.43
2012-05-09 00:00:00 | 21:29:00 | 2143-05-14 00:00:00 | 2012-05-09 21:29:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.03 | 141.41 | Available for Transfer Now
2012-05-09 00:00:00 | 21:29:00 | 2143-05-14 00:00:00 | 2012-05-09 21:29:00 | Credit | [NAME] (xxx) with ??? | 0.5 | 141.91
2012-05-09 00:00:00 | 21:32:00 | 1960-11-02 00:00:00 | 2012-05-09 21:32:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.3 | 141.61 | Available for Transfer Now
2012-05-09 00:00:00 | 21:32:00 | 1960-11-02 00:00:00 | 2012-05-09 21:32:00 | Credit | [NAME] (xxx) with ??? | 5.93 | 147.54
2012-05-10 00:00:00 | 20:59:00 | 2052-02-07 00:00:00 | 2012-05-10 20:59:00 | Debit | [NAME] May 10 2012 21:00 to 21:59 1.50 crd(s) (P10) | -1.5 | 146.04 | Available for Transfer Now
2012-05-11 00:00:00 | 00:51:00 | 2082-07-10 00:00:00 | 2012-05-11 00:51:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.53 | 145.51
2012-05-11 00:00:00 | 00:51:00 | 2082-07-10 00:00:00 | 2012-05-11 00:51:00 | Credit | [NAME] (xxx) with ??? | 1.78 | 147.28
2012-05-11 00:00:00 | 00:56:00 | 2143-05-14 00:00:00 | 2012-05-11 00:56:00 | Debit | [NAME] (xxx) Facility Fee, with ??? | -0.37 | 146.92 | Available for Transfer Now
2012-05-11 00:00:00 | 00:56:00 | 2143-05-14 00:00:00 | 2012-05-11 00:56:00 | Credit | [NAME] (xxx) with ??? | 1.83 | 148.74
2012-05-11 00:00:00 | 00:59:00 | 1960-11-02 00:00:00 | 2012-05-11 00:59:00 | Debit | [NAME] May 11 2012 01:00 to 01:59 0.30 crd(s) (P1) | -0.3 | 148.44 | Available for Transfer Now
2012-05-11 00:00:00 | 20:37:00 | 2112-12-11 00:00:00 | 2012-05-11 20:37:00 | Credit | 24 Hours subscription  xxxxxxxxxxxxxxxxxx, Expires xxxx | 0.5 | 148.94
2012-05-12 00:00:00 | 10:59:00 | 2143-05-14 00:00:00 | 2012-05-12 10:59:00 | Debit | [NAME] May 12 2012 11:00 to 11:59 1.00 crd(s) (P4) | -1 | 147.94 | Available for Transfer Now
2012-05-13 00:00:00 | 17:46:00 | 2112-12-11 00:00:00 | 2012-05-13 17:46:00 | Credit | 3 Days subscription  xxxxxxxxxxxxxxxxxx, Expires xxx | 0.5 | 148.44
2012-05-13 00:00:00 | 17:53:00 | 2143-05-14 00:00:00 | 2012-05-13 17:53:00 | Credit | 24 Hours subscription  xxxxxxxxxxxxxxxxxx, Expires xxxx | 0.5 | 148.94 | Available for Transfer Now