Please do not discuss (or even mention) current puzzles until after the solution is published. The moderators reserve the right to delete messages which do not have a valid Email address.
Re(1): A small Excel-based solution to Listener 4438 (Can't You Do Division? by Oyler) IP: 87.115.225.29 Posted on March 24, 2017 at 04:46:56 PM by Tony Jollans
I don't really want to solve puzzles on the computer, but do occasionally use Excel to generate lists of numbers, although I am somewhat out of practice.
Clearly your page, to which I will return when I have more time, does a lot more, but generating the list of pandigital squares can be done relatively easily in Excel.
There are, no doubt, better formulae but array-enter (Ctrl+Shift+Enter) this in A1:
This calculates the square of (the row number plus 9999), then adds up the total number of different digits (1-9) that exist in the square, and fills the cell with the square only if the total is 9.
Copy down to around A22000 (at least as far as A21623, or root(999999999) - 9999). There is no very easy way to do this but select A1, enter A1:A22000 in the name box, press Enter, and then Ctrl+D.
Put a filter on column A, of not equal to "", and there you have your list. Replies: