user defined function - appendArrays

Chris,

Pretty much any unique formula is a user defined function. I guess what separates a formula from a function is that you are wrapping the formula in the function format then you can call the "function" which executes your formula. Clear as mud right!

I assume those numbers will change so how do you get the numbers that you want to exclude? I won't be able to respond for a while after this post btw.

Sean

Hopefully, this better explains the difference between a plain ole formula and a user defined function...

The following code works...

let mySquare := [3, 6, 7, 8];
let myRow := [3, 7];
let myCol := [3, 7, 9];
let subNumbers := unique(mySquare, myRow, myCol);
let posNumbers := [0];
let allNumbers := [1, 2, 3, 4, 5, 6, 7, 8, 9];
for i in range(0, count(allNumbers)) do
let lpCount := 0;
let numFound := false;
while lpCount < count(subNumbers) and not numFound do 
if item(subNumbers, lpCount) = item(allNumbers, i) then
numFound := true
else
lpCount := lpCount + 1
end
end
;
if not numFound then
posNumbers := unique(posNumbers, item(allNumbers, i))
end
end;
posNumbers := slice(posNumbers, 1, count(posNumbers));
posNumbers

I don't know if you really need to store the values in the arrays as numbers. If you can store the numbers as text it would be easy to pass the stringified arrays to a user defined function.