10km doesn't take you out of SH which should make it easier
So i think that makes the pseudofilter for your 10x10 box
NG Letters = SH
Easting between 5378 and 7378
AND Northing between 4143 and 6143
Much appreciate the seemingly positive/achievable reply
Regrettably, I'm thick and too old/brain elsewhere
What is a "pseudofilter" and how in child like steps, would one apply such a thing?
In Numbers on a Mac, as per the screenshot, choose Select All from the Edit menu, then go to Organise (top right), click Filter, then add rules for each of the above.
Thanks FifeingEejit and grams Much appreciated
Brilliant! I've just performed my first ever pseudo filter and it worked
Ah but a pseudofilter is just a non-implementation specific description of a filter (see also pseudocode).
So you've actually just performed your first ever filter in your spreadsheet of choice.
Not being a mac user I had no idea of the spreadsheet software you were using so didn't want to give you an Excel formula (which is what I use)
As for the origin of "SH" being 200000 300000, I didn't have a 1940s New Popular 1 inch map handy to get them.
Using a 10km square is by far the easiest to figure out, if you do want a radius based filter then rather than doing all the maths there's probably something in the google api to load the benchmarks in and then apply a 10km radius circle to it.