Spreadsheet: 39636d1237918923-lookup-across-3-columns-to-get-total-value-sumproduct-datesandcategorysummary
Sheet: Sheet2

PropNo | CustCode | zone | [NAME] | cat | networkname | PropName | Address1 | Address2 | Address3 | City | State | PinCode | TelNo | [NAME] | Prop DOB | married | spousename | dobspouse | AnniversaryDate
[PHONE]-1 | 221000000133 | N | NZ011 | SILVER | Jind Cable Network | Ravinder [NAME] | 414/11 | [NAME] | Near Bhuteshwar Mandiar, Safiden gate | [NAME] | HARYANA | 126102 | 01681-256223 | 9416060725 | 1964-10-20 00:00:00 | 2 | [NAME] | 1970-10-10 00:00:00 | 1989-02-10 00:00:00
[PHONE]-2 | 221000000232 | N | NZ002 | SILVER | City Communication | [NAME] | H No BS 37/33 A | Prbha Niwas Turi Bazar | na | [NAME] city | Punjab | na | 01632-222277 | 9356610923 | 1955-02-07 00:00:00 | 2 | Sashi prabha | 1956-02-05 00:00:00 | 1978-03-05 00:00:00
[PHONE]-3 | 221000000232 | N | NZ002 | SILVER | City Communication | Parshotam [NAME] | In Side megzini Gate | Kucha | Shri Guru Das mal [NAME] | Ferojpur | Punjab | 150002 | 01632-224101 | 9316331200 | 1948-11-22 00:00:00 | 2 | [NAME] | 1953-09-21 00:00:00 | 1972-06-10 00:00:00
[PHONE]-1 | 221000000406 | N | NZ012 | BLUE | Force Cable Tv Net Work | [NAME] | S/o [NAME] | Vill hariyawas | [NAME], [NAME] | Bhiwani | HARYANA | 127028 | [PHONE] | 9813139230 | 1968-03-31 00:00:00 | 2 | [NAME] | 1972-08-15 00:00:00 | 1990-05-09 00:00:00
[PHONE]-2 | 221000000497 | N | NZ003 | GOLD | Star City Cable N/W | [NAME] | H No 116 | Street No 4 | Dyanand Nagar [NAME] | Amritsar | Punjab | Na | [PHONE] | 9814050613 | 1958-11-10 00:00:00 | 2 | Dolly Sarabjeet Singh | 1964-09-22 00:00:00 | 1983-09-04 00:00:00
[PHONE]-1 | 221000000513 | N | NZ013 | GOLD | Rajdhani Communication Network Ltd | [NAME] | C-159 | [NAME] | Phase - I | Delhi | DELHI | 110052 | 27453388 | 9810007732 | 1965-03-16 00:00:00 | 2 | Promila | 1971-06-04 00:00:00 | 1992-01-26 00:00:00
[PHONE]-1 | 221000000620 | N | NZ003 | BLUE | saini cable | [NAME] | [NAME] | V P O I *hajipur | Dist hHoshiarpur | Hajipur | Punjab | 144221 | 01883-272127 | 9815628727 | 1957-04-20 00:00:00 | 2 | Kuldip kaur | 1960-04-25 00:00:00 | 1984-10-21 00:00:00
[PHONE]-1 | 221000000638 | N | NZ003 | BLUE | gat body of bbmb cable system at | [NAME] | 12 | Type 6, Sector 2 | Talwara Township | talwara | Punjab | 144216 | * | 9417349535 | * | 2 | Sonu Sharma | 1969-12-23 00:00:00 | 1992-01-28 00:00:00
[PHONE]-1 | 221000000661 | N | NZ001 | BLUE | City Cable Opera | Naresh Mittal | H NO 227 | STREET NO 7 | Old Bishan Nagar | Patiala | Punjab | 147001 | 17525373303 | 9814006363 | 1962-07-15 00:00:00 | 2 | [NAME] | 1962-01-01 00:00:00 | 1990-12-12 00:00:00
[PHONE]-1 | 221000000679 | N | [NAME] | BLUE | varun cable net work | [NAME] | 13/158 | varun cable net work | manik chowk | aligarh | Uttar Pradesh | 202001 | [PHONE] | 9412273661 | 1970-01-14 00:00:00 | 2 | smt shalni | 1972-04-26 00:00:00 | 1993-06-07 00:00:00
[PHONE]-1 | 221000000836 | N | NZ002 | BLUE | Ransi Cable Tv | [NAME] | VPO Dehlon | [NAME] | Dist [NAME] | Dehlon | Punjab | 141418 | [PHONE] | 9814775466 | 1976-04-25 00:00:00 | 2 | Poonam | 1976-12-20 00:00:00 | 2000-06-08 00:00:00
[PHONE]-2 | 221000000976 | N | NZ001 | BLUE | Baghal Cable Network | [NAME] | Bridge View Hotel | The Mall Shimla | Na | Shimla | HIMACHAL PRADESH | 171001 | Na | 9218523456 | 1967-06-13 00:00:00 | 2 | Anamika [NAME] | 1974-04-28 00:00:00 | 1991-08-02 00:00:00
[PHONE]-1 | 221000001206 | N | [NAME] | SILVER | Goldy Dish Antenna | [NAME] | W/o [NAME] | 136 | [NAME] | Banswara | [NAME] | 327001 | 02962-248398 | 9414101899 | 1965-05-29 00:00:00 | 2 | [NAME] | 1959-02-27 00:00:00 | 1989-05-24 00:00:00
[PHONE]-1 | 221000001388 | N | NZ013 | SILVER | Pawan Cable *Network | [NAME] | U-105 | [NAME] | Narela | New Delhi | DELHI | 110040 | 27283245 | 9891099995 | 1976-04-20 00:00:00 | 2 | Rekha | 1977-06-10 00:00:00 | 1996-03-17 00:00:00
[PHONE]-1 | 221000001495 | N | NZ015 | BLUE | I T I infosat Club | [NAME] | c- 48 | Sector 1 | [NAME], Raibareli | raibareli | Uttar Pradesh | 229010 | 0535-287510 | 9415744536 | 1966-03-28 00:00:00 | 2 | [NAME] | 1970-02-22 00:00:00 | 1991-02-17 00:00:00
[PHONE]-2 | 221000001495 | N | NZ015 | BLUE | I T I infosat Club | Anil Kumar Mittal | B-148 | Sector 1 | Doorbhash Nagar | Raibareli | Uttar Pradesh | 229010 | 0535-287207 | 9415155233 | 1952-08-01 00:00:00 | 2 | Alka Mittal | 1961-11-21 00:00:00 | 1981-01-17 00:00:00
[PHONE]-1 | 221000001511 | N | NZ013 | SILVER | Sky Channel | [NAME] | B3B/93C | Janakpuri | Na | New Delhi | DELHI | 110058 | 25508471 | 9811089043 | 1948-10-23 00:00:00 | 1 | * | * | *