I then modified the proposed solution to change "Firstnonblank" to "Lastnonblank" and set TopN to "2" and "3", respectively, in order to calculate the 2nd and 3rd nearest school to each postcode. However, unfortunately the TopN function didn't always give ...
The Lat/Long is 53 03′ 08N, 4 01′ 01W. Note that a number of older SatNavs give incorrect locations for this postcode LL55 4NW and place the campsite at the wrong end of the lake! Google Maps and Ordnance Survey maps show the campsite correctly at the north end of the lake....