User-Defined Functions won't work with each other

[SoothSailor]

Howdy,

I have two functions. SPACE_OVERLAP() finds common numbers between two cells with comma-delimited values like this:
A1: 1,2,3,4,5,6,7,8,9
A2: 4,5,8,10,12,13,14,15
B1: =SPACE_OVERLAP(A1,A2) = 4,5,8

And NUMCOMMA() turns a cell into a comma-delimited value, like this:
A1: 1-5
A2: =NUMCOMMA(A1) = 1,2,3,4,5

The problem is that when I put NUMCOMMA() inside of SPACE_OVERLAP()
=SPACE_OVERLAP(A1,NUMCOMMA(A2))
I get a #VALUE error.

Space Overlap:

Please Login or Register  to view this content.

Numcomma:

Please Login or Register  to view this content.

[shg]

Because Space_Overlap is expecting two ranges. Change the arguments to String.

[SoothSailor]

And there we have it. Under my nose the whole time. Thanks!

[shg]

I'd do the same for the other one.

You're welcome.