Spreadsheet: 103983d1301608110-how-to-use-if-function-to-trafer-data-to-2nd-sheet-based-on-date-eom-tracker-ii
Sheet: EOM Tracker

 |  |  |  |  |  |  |  |  |  |  | Yes
2 |  | Last day of previous month |  |  |  |  |  |  |  |  | No
 |  |  |  | 2011-02-28 00:00:00
 | Account No. | Name | Amount | Collector | Pst due date | Maturity date | CC Name | Will loan drop? |  | City | Name | Total amt. | Total active hit | Total matured hit | Total no. of loans | No. of active loans | No. of matured loans
 |  |  |  |  |  |  |  |  |  | Beaumont
 |  |  |  |  |  |  |  | No |  | Brownsville
 |  |  |  |  |  |  |  | No |  | College Station
 |  |  |  |  |  |  |  | No |  | Corpus Christi
 |  |  |  |  |  |  |  |  |  | El Paso
 |  |  |  |  |  |  |  |  |  | Harlingen
 |  |  |  |  |  |  |  |  |  | Hidalgo
 |  |  |  |  |  |  |  | No |  | Houston
 |  |  |  |  |  |  |  | No |  | [NAME]
 |  |  |  |  |  |  |  | No |  | Laredo
 |  |  |  |  |  |  |  | No |  | Las Cruces
 |  |  |  |  |  |  |  | No |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Mission
 |  |  |  |  |  |  |  | No |  | [NAME]
 |  |  |  |  |  |  |  | No |  | Ruidoso
 |  |  |  |  |  |  |  | No |  | Weslaco
 |  |  |  |  |  |  |  |  |  | Total:
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No |  | Collector | Name | Total amt. | Total active hit | Total matured hit | Total no. of loans | No. of active loans | No. of matured loans
 |  |  |  |  |  |  |  | No |  | Alabama
 |  |  |  |  |  |  |  | No |  | Esmer
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | No |  | Juanita
 |  |  |  |  |  |  |  | No |  | Julian
 |  |  |  |  |  |  |  | No |  | [NAME]
 |  |  |  |  |  |  |  | No |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Nydia
 |  |  |  |  |  |  |  |  |  | Olivia
 |  |  |  |  |  |  |  |  |  | Oralia
 |  |  |  |  |  |  |  | No |  | Roel
 |  |  |  |  |  |  |  | No |  | Rommie
 |  |  |  |  |  |  |  | No |  | Sonia
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Thelma
 |  |  |  |  |  |  |  | No |  | Yolo
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No |  | Total:
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  | No