Spreadsheet: 216559d1361810276-stuck-with-an-if-or-then-or-and-or-vlookup-or-count-or-sum-any-help-rptexcelforum-data-2013
Sheet: Sheet2

cts_type | last_name | in_date | out_date | status | Comm | nights | rooms | prop_name | prop_country | prop_address1 | prop_city | prop_phone | branch | extra1 | extra2 | extra3 | extra4 | extra5 | deposit_date | check_num | check_date | unmatched | pay_start | pay_end
1 | TVEITARAASJACK | 2011-03-13 00:00:00 | 2011-03-17 00:00:00 | A | 36.05 | 4 | 1 | [NAME] | US | 5 RUE DUQUESNOY | BRUSSELS | 3225055555 | 20 | 1M98 | 1M98 | HK | [NAME] |  | 2012-01-31 00:00:00 | 62105521 |  | N | 2012-01-31 00:00:00 | 2012-01-31 00:00:00
1 | PAPPADEMOS | 2011-03-20 00:00:00 | 2011-03-24 00:00:00 | A | 81.49 | 4 | 1 | CARIBE HOTEL | US | [NAME] 1A NO 2-87 | CARTAGENA | 5756650155 | 20 | 1M98 | 1M98 | HK | LV0 |  | 2012-01-09 00:00:00 | 62079805 |  | N | 2012-01-09 00:00:00 | 2012-01-09 00:00:00
1 | BROCKMAN | 2011-05-12 00:00:00 | 2011-05-13 00:00:00 | A | 7.6 | 1 | 1 | THE MARLBOROUGH HOTEL | US | 331 SMITH STREET | WINNIPEG | 2049426411 | 49 | 1CO2 | 1CO2 | HK |  | RADIUS | 2012-01-06 00:00:00 | 738 |  | N | 2012-01-06 00:00:00 | 2012-01-06 00:00:00
1 | MUHAMMAD | 2011-05-15 00:00:00 | 2011-05-17 00:00:00 | A | 15.39 | 2 | 1 | THE MARLBOROUGH HOTE | US | 331 SMITH STREET | WINNIPEG | 2049426411 | 49 | 1CO2 | 1CO2 | BK |  |  | 2012-01-06 00:00:00 | 738 |  | N | 2012-01-06 00:00:00 | 2012-01-06 00:00:00
1 | GARNER | 2011-05-15 00:00:00 | 2011-05-16 00:00:00 | A | 16.11 | 1 | 1 | AMBASSADOR EAST HOT | US | 1301 NORTH STATE PARKWAY | CHICAGO IL | 3127877200 | 49 |  |  | 0 |  |  | 2012-01-09 00:00:00 | 62069270 |  | N | 2012-01-09 00:00:00 | 2012-01-09 00:00:00
1 | RHIND | 2011-05-23 00:00:00 | 2011-05-24 00:00:00 | A | 16.65 | 1 | 1 | AMBASSADOR EAST HOTEL | US | 1301 NORTH STATE PARKWAY | CHICAGO | 3127877200 | 49 | 1CO2 | 1CO2 | HK | WTT | WTT | 2012-01-09 00:00:00 | 62069270 |  | N | 2012-01-09 00:00:00 | 2012-01-09 00:00:00
1 | FITZMARTIN | 2011-06-16 00:00:00 | 2011-06-18 00:00:00 | A | 15.2 | 2 | 1 | THE MARLBOROUGH HOT | CA | THE MARLBOROUGH HOT | WINNIPEG | 2049426411 | 49 |  |  | 0 |  |  | 2012-01-06 00:00:00 | 738 |  | N | 2012-01-06 00:00:00 | 2012-01-06 00:00:00
1 | GAVIN | 2011-07-08 00:00:00 | 2011-07-09 00:00:00 | A | 5 | 1 | 1 | ECONO LODGE LEXINGT | US | 5527 ATHENS-BOONESBORO RD | LEXINGTON | 8592635101 | 73 |  |  |  |  |  | 2012-01-19 00:00:00 | 11594705 | 2012-01-19 00:00:00 | N | 2012-01-19 00:00:00 | 2012-01-19 00:00:00
1 | MORGAN | 2011-07-13 00:00:00 | 2011-07-14 00:00:00 | A | 17.91 | 1 | 1 | HYATT REG WAIKIKI R | US | 2424 KALAKAUA AVE | HONOLULU HI | 8089231234 | 49 |  |  |  |  |  | 2012-01-26 00:00:00 | 11605281 | 2012-01-26 00:00:00 | N | 2012-01-26 00:00:00 | 2012-01-26 00:00:00
1 | STOLLON | 2011-07-20 00:00:00 | 2011-07-21 00:00:00 | A | 6.9 | 1 | 1 | [NAME] | DR | 5150 FAIRVIEW DR | FAIRVIEW | 7158526000 | 47 |  |  | 0 |  |  | 2012-01-06 00:00:00 | 5219 |  | N | 2012-01-06 00:00:00 | 2012-01-06 00:00:00
1 | FONKERT | 2011-07-26 00:00:00 | 2011-07-28 00:00:00 | A | 30.4 | 2 | 1 | RESIDENCE INN ROSEV | US | 1930 TAYLOR ROAD | ROSEVILLE | 9167725500 | 47 |  |  | 0 |  |  | 2012-01-18 00:00:00 | 5551 |  | N | 2012-01-18 00:00:00 | 2012-01-18 00:00:00
1 | GRADEN | 2011-08-02 00:00:00 | 2011-08-04 00:00:00 | A | 31.95 | 2 | 1 | [NAME] TAKANA | JP | 3-13-1 TAKANAWA MINATO-KU | TOKYO | 81334471111 | 20 |  |  | 0 |  |  | 2012-01-31 00:00:00 | 62104979 |  | N | 2012-01-31 00:00:00 | 2012-01-31 00:00:00
1 | ARNOT | 2011-08-11 00:00:00 | 2011-08-12 00:00:00 | A | 13.4 | 1 | 1 | HOLIDAY INN AIRPORT | US | 911 BROOKS AVENUE | ROCHESTER | 5853286000 | 20 |  |  | 0 |  |  | 2012-01-30 00:00:00 | 1543 |  | N | 2012-01-30 00:00:00 | 2012-01-30 00:00:00
1 | LANG | 2012-01-24 00:00:00 | 2012-01-25 12:00:00 | N | 0 | 1 | 1 | HILTON GARDEN INN WH | US | HILTON GARDEN INN WH | BALTIMORE | 4104270600 | 47 |  |  |  |  |  | 2012-02-09 00:00:00 | 11623133 | 2012-02-09 00:00:00 | N | 2012-02-09 00:00:00 | 2012-02-09 00:00:00
1 | KRAGTHORPE | 2012-01-24 00:00:00 | 2012-01-25 12:00:00 | N | 0 | 1 | 1 | HOMEWOOD MEM EAST | US | 5811 POPLAR AVE. | MEMPHIS | 9017630500 | 86 |  |  |  |  |  | 2012-02-09 00:00:00 | 11623133 | 2012-02-09 00:00:00 | N | 2012-02-09 00:00:00 | 2012-02-09 00:00:00
1 | KNOX | 2012-01-24 00:00:00 | 2012-01-26 12:00:00 | A | 30.85 | 2 | 1 | DOUBLETREE OAKBROOK | US | 1909 SPRING ROAD | OAK BROOK | 6304726000 | 49 |  |  |  |  |  | 2012-02-09 00:00:00 | 11623133 | 2012-02-09 00:00:00 | N | 2012-02-09 00:00:00 | 2012-02-09 00:00:00
1 | KNIGHT | 2012-01-24 00:00:00 | 2012-01-28 12:00:00 | N | 0 | 4 | 1 | HILTON GI AMES | US | 1325 DICKINSON AVE | AMES | 5152338000 | 20 |  |  |  |  |  | 2012-02-09 00:00:00 | 11623133 | 2012-02-09 00:00:00 | N | 2012-02-09 00:00:00 | 2012-02-09 00:00:00
1 | KING | 2012-01-24 00:00:00 | 2012-01-26 12:00:00 | A | 19.21 | 2 | 1 | HILTON GI BOWLING G | US | 1020 WILKINSON TRACE | BOWLING GREEN | 2707816778 | 15 |  |  |  |  |  | 2012-02-09 00:00:00 | 11623133 | 2012-02-09 00:00:00 | N | 2012-02-09 00:00:00 | 2012-02-09 00:00:00
1 | [NAME] | 2012-01-24 00:00:00 | 2012-01-26 12:00:00 | N | 0 | 2 | 1 | HOMEWOOD STE CINCIN | US | 2670 E. KEMPER RD. | SHARONVILLE | 5137728888 | 15 |  |  |  |  |  | 2012-02-09 00:00:00 | 11623133 | 2012-02-09 00:00:00 | N | 2012-02-09 00:00:00 | 2012-02-09 00:00:00
1 | SPANDET | 2012-01-25 00:00:00 | 2012-01-27 12:00:00 | A | 33.8 | 2 | 1 | HP DES MOINES | US | 418 6TH AVE. | DES MOINES | 5152825555 | 22 |  |  |  |  |  | 2012-02-23 00:00:00 | 11642940 | 2012-02-23 00:00:00 | N | 2012-02-23 00:00:00 | 2012-02-23 00:00:00
1 | ZALEWSKI | 2012-01-25 00:00:00 | 2012-01-26 12:00:00 | N | 0 | 1 | 1 | [NAME] | US | 5400 WESTON RD | EVANSVILLE | 8124290900 | 49 |  |  | 0 |  |  | 2012-02-23 00:00:00 | 7398673 |  | N | 2012-02-23 00:00:00 | 2012-02-23 00:00:00
1 | SCARABINO | 2012-01-25 00:00:00 | 2012-01-28 12:00:00 | A | 172 | 3 | 1 | THE BUCCANEER | VI | ESTATE SHOYS | CHRISTIANSTED | 3407122100 | 15 |  |  | 0 |  |  | 2012-02-22 00:00:00 | 4564 |  | N | 2012-02-22 00:00:00 | 2012-02-22 00:00:00
1 | LAGOS | 2012-01-25 00:00:00 | 2012-01-26 00:00:00 | C | 0 | 1 | 1 | HAMPTON INN BROOKSVILLE D | US | 30301 CORTEZ BLVD | BROOKSVILLE | 3527961000 | 30 | 8PH0 | 8PH0 | HK | A08 | 1631000 | 2012-02-16 00:00:00 | 11632914 | 2012-02-16 00:00:00 | N | 2012-02-16 00:00:00 | 2012-02-16 00:00:00
1 | WOOD | 2012-01-26 00:00:00 | 2012-01-27 00:00:00 | C | 0 | 1 | 1 | [NAME], FL | US | 3050 N. ROCKY POINT DR. W | TAMPA | 8138888800 |  |  |  |  |  |  | 2012-02-09 00:00:00 | 11623133 | 2012-02-09 00:00:00 | Y | 2012-02-09 00:00:00 | 2012-02-09 00:00:00
1 | GRINOLD | 2012-01-26 00:00:00 | 2012-01-27 12:00:00 | A | 11.5 | 1 | 1 | OHANA WKK MALIA | US | 2211 KUHIO AVE | HONOLULU | 8089237621 | 49 |  |  | 0 |  |  | 2012-02-06 00:00:00 | 654090 |  | N | 2012-02-06 00:00:00 | 2012-02-06 00:00:00
1 | BREWER | 2012-01-26 00:00:00 | 2012-01-27 12:00:00 | A | 13 | 1 | 1 | HAMPTON STES MGM E | US | 7651 EASTCHASE PARKWAY | MONTGOMERY | 3342771818 | 20 |  |  |  |  |  | 2012-02-09 00:00:00 | 11623133 | 2012-02-09 00:00:00 | N | 2012-02-09 00:00:00 | 2012-02-09 00:00:00
1 | BRYANT | 2012-01-26 00:00:00 | 2012-01-27 12:00:00 | A | 11.43 | 1 | 1 | HAMPTON INN OVERLAN | US | 10591 METCALF FRONTAGE RO | OVERLAND PARK | 9133411551 | 20 |  |  |  |  |  | 2012-02-09 00:00:00 | 11623133 | 2012-02-09 00:00:00 | N | 2012-02-09 00:00:00 | 2012-02-09 00:00:00