Spreadsheet: 350626d1412840582-comparing-information-on-2-different-pivot-tables-full-list-workings-in-pivot-small-
Sheet: Collection1

Price | Suburb | City | Size | Land |  |  | PRICE | CITY | SUBURB | SIZE
$464,000 | Oxford | Waimakariri | 4 bedrooms
Price by negotiation | City Centre | Auckland City | 2 bedrooms
Price by negotiation | Riversdale Beach | Masterton | 4 bedrooms
Price by negotiation | Rotorua | Rotorua |  | 32.48 hectares (80.25 acres)
$1,250,000 | [NAME] | Franklin | 6 or more bedrooms
Enquiries over $785,000 | Melrose | Wellington | 4 bedrooms
$499,000 | Takanini | Papakura | 3 bedrooms
Price by negotiation | Silverdale | [NAME] |  | 6.5 hectares (16.06 acres)
Price by negotiation | [NAME] | Gisborne | 5 bedrooms | 2.4 hectares (5.93 acres)
$1,150,000 | Lake Tarawera | Rotorua | 5 bedrooms
$425,000 | Putaruru | South Waikato | 4 bedrooms | 0.7 hectares (1.73 acres)
$185,000 | Runanga | Grey | 3 bedrooms
$289,000 | City Centre | Auckland City | 3 bedrooms
$929,000 | Muriwai Valley | [NAME] | 4 bedrooms
$385,000 | Otahuhu | Auckland City | 3 bedrooms
$495,000 | One Tree Point | Whangarei | 4 bedrooms
$175,000 | Avenal | Invercargill | 3 bedrooms
Price by negotiation | [NAME] | Gisborne | 3 bedrooms | 0.31 hectares (0.76 acres)
$700,000 | Waipukurau | [NAME] Bay | 4 bedrooms | 10.3 hectares (25.45 acres)
$65,000 | National Park | [NAME] | 846 m 2;Save to watchlist;Listed Tue
$660,000 | Whitianga | Thames-Coromandel | 3 bedrooms
Price by negotiation | Millers Flat | Central Otago |  | 2.7 hectares (6.67 acres)
$525,500 | Petone | Lower Hutt | 3 bedrooms
$553,000 | Petone | Lower Hutt | 3 bedrooms
$527,500 | Petone | Lower Hutt | 3 bedrooms
$540,500 | Petone | Lower Hutt | 3 bedrooms
$950,000 | Mount Maunganui | Tauranga | 5 bedrooms
Price by negotiation | [NAME] | Manukau City | 509 m 2;Save to watchlist;Graeme Sun;Listed Tue
$101,000 | South New Brighton | Christchurch City | 614 m 2;Save to watchlist;Louise McLeavey;Listed Tue
Price by negotiation | [NAME] | Manukau City | 6 or more bedrooms
$488,000 | [NAME] | Manukau City | 397 m 2;Save to watchlist;Graeme Sun;Listed Tue
Price by negotiation | [NAME] | Whangarei | 3 bedrooms
$395,000 | Hunua | Franklin | 7034 m 2;Save to watchlist;Richard Sumner;Listed Tue
$122,000 | [NAME] | [NAME]
Price by negotiation | Great Barrier Island | Hauraki Gulf Islands | 1 bedroom
$170,200 | Wyndham | Southland | 3 bedrooms
Price by negotiation | Onekawa | Napier | 3 bedrooms
Price by negotiation | Mangonui | Far North | 766 m 2;Save to watchlist;Listed Tue
$209,000 | Naenae | Lower Hutt | 3 bedrooms
$149,000 | Picton | Marlborough | 1050 m 2;Save to watchlist;Listed Tue
Enquiries over $260,000 | [NAME] | [NAME] | 809 m 2;Save to watchlist;Listed Tue
$825,000 | Parnell | Auckland City | 3 bedrooms
$345,000 | Putaruru | South Waikato | 4 bedrooms
$395,000 | Mount Eden | Auckland City | 1 bedroom
$585,000 | Mount Eden | Auckland City | 2 bedrooms
$618,000 | Mount Eden | Auckland City | 2 bedrooms
$395,000 | Mount Eden | Auckland City | 1 bedroom
$99,000 | Wairoa | Wairoa | 3 bedrooms
$758,800 | Mount Eden | Auckland City | 3 bedrooms
$127,000 | Westport | [NAME] | 3 bedrooms
Price by negotiation | Stillwater | [NAME] | 140500 m 2;Save to watchlist;Joseph Foo;Listed Tue
Deadline private treaty | Kawaha Point | Rotorua | 3 bedrooms
$588,000 | Mount Eden | Auckland City | 2 bedrooms
$419,000 | Army Bay | [NAME] | 1093 m 2;Save to watchlist;Benji Kim;Listed Tue
$339,000 | Karamea | [NAME] | 3 bedrooms
$65,000 | Karamea | [NAME] | 1149 m 2;Save to watchlist;Joelle Fox;Listed Tue
$798,000 | Mount Eden | Auckland City | 3 bedrooms
Enquiries over $700,000 | Kauri | Whangarei | 3 bedrooms
$1,175,000 | Clyde | Central Otago | 4 bedrooms | 2 hectares (4.94 acres)
$460,000 | Greymouth | Grey | 4 bedrooms
$895,000 | Ohoka | Waimakariri | 5 bedrooms | 4.25 hectares (10.5 acres)
$980,000 | Gulf Harbour | [NAME] | 1371 m 2;Save to watchlist;Shirley Wills;Listed Tue
Price by negotiation | Papakura | Papakura | 5 bedrooms
$1,050,000 | Opua | Far North | 3 bedrooms
$65,000 | Karamea | [NAME] | 1137 m 2;Save to watchlist;Joelle Fox;Listed Tue
$349,000 | Papakura | Papakura | 3 bedrooms
$90,000 | Karamea | [NAME] | 11000 m 2;Save to watchlist;Joelle Fox;Listed Tue
$105,000 | Karamea | [NAME] | 9440 m 2;Save to watchlist;Joelle Fox;Listed Tue
$585,000 | Mount Eden | Auckland City | 2 bedrooms
$408,000 | Mount Eden | Auckland City | 1 bedroom
$115,000 | Karamea | [NAME] | 14161 m 2;Save to watchlist;Joelle Fox;Listed Tue
$718,000 | Mount Eden | Auckland City | 3 bedrooms
$1,250,000 | Governors Bay | Banks Peninsula | 5 bedrooms
$1,700,000 | Port Levy | Banks Peninsula | 4 bedrooms | 83.78 hectares (207.02 acres)
$365,000 | Great Barrier Island | Hauraki Gulf Islands
Enquiries over $500,000 | [NAME] | Waikato | 5 bedrooms | 0.53 hectares (1.3 acres)
Enquiries over $465,000 | Otorohanga | Otorohanga | 4 bedrooms | 1 hectare (2.47 acres)
$365,000 | Whakatane | Whakatane | 3 bedrooms
Enquiries over $355,000 | Kensington | Whangarei | 3 bedrooms
$860,000 | Paeroa | Hauraki | 5 bedrooms | 9.3 hectares (22.98 acres)
$375,000 | Nukuhau | [NAME] | 3 bedrooms
Enquiries over $409,000 | [NAME] | Horowhenua | 3 bedrooms
Price by negotiation | [NAME] | Manukau City
$305,000 | [NAME] | Tararua | 4 bedrooms
Price by negotiation | Ranui | Waitakere City | 6 or more bedrooms
$1,077,750 | Beachlands | Manukau City | 5 bedrooms
$582,000 | Otorohanga | Otorohanga | 4 bedrooms | 1.43 hectares (3.53 acres)
$425,000 | Coromandel | Thames-Coromandel | 2 bedrooms
Price by negotiation | Ashburton | Ashburton | 5 bedrooms | 0.9 hectares (2.22 acres)
$87,500 | Waiau | Hurunui | 1831 m 2;Save to watchlist;Listed Mon
Enquiries over $459,000 | Belfast | Christchurch City | 3 bedrooms
$329,000 | [NAME] | [NAME] | 4 bedrooms
$497,000 | Paeroa | Hauraki | 5 bedrooms
Enquiries over $430,000 | Moturoa | New Plymouth | 3 bedrooms
Price by negotiation | Stokes Valley | Lower Hutt | 5 bedrooms
$210,000 | Murchison | Tasman | 3 bedrooms
Enquiries over $499,000 | [NAME] | Dunedin | 4 bedrooms
Enquiries over $299,000 | Ocean Grove | Dunedin | 4 bedrooms
$649,000 | Halswell | Christchurch City | 3 bedrooms
$640,000 | Halswell | Christchurch City | 4 bedrooms
$635,000 | Halswell | Christchurch City | 4 bedrooms
Enquiries over $159,000 | [NAME] | Dunedin | 2 bedrooms
$409,000 | Te Awamutu | Waipa | 3 bedrooms
$180,000 | Linwood | Christchurch City
$254,000 | Te Awamutu | Waipa | 3 bedrooms
$695,000 | [NAME] | Waikato | 5 bedrooms | 0.17 hectares (0.42 acres)
Price by negotiation | Riversdale | Southland | 3 bedrooms
Price by negotiation | Awhitu | Franklin |  | 1 hectare (2.47 acres)
Price by negotiation | Belmont | Lower Hutt | 5 bedrooms