Derek Harrison's Crossword Message Board

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.

Message Board Rules

Re(1): A small Excel-based solution to Listener 4438 (Can't You Do Division? by Oyler)
IP: 87.115.225.29


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:

=IF(SUM(IF(ISNUMBER(FIND(ROW($1:$9),TEXT((ROW()+9999)^2,"@"))),1,0))=9,(ROW()+9999)^2,"")

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:



Post a reply:
Name:
Email:
Subject:
Message:
Link Name:
Link URL:
Image URL:
Check this box if you want to be notified via email when someone replies to your post.

Create Your Own Free Message Board or Free Forum!
Hosted By Boards2Go Copyright © 2000-2015
Our Sites: Wedding address collection  Wedding thank you wording