Suppose to return an array, but doesn't :(

[gosbra]

Hello,
I'm trying to borrow someone else's VBA, and it isnt clicking for me. When using False for the second argument, the function is suppose to return an array. Im not getting an array though. The function is only return the first unique value. I need this for work, so Im really stressing over it. Please help.

Please Login or Register  to view this content.

[Norie]

How are you using the function?

When I try it with a simple array it is return an array of unique values.

[gosbra]

Oh, man. I must be making a silly mistake?
I inserted the following function into a cell...

Please Login or Register  to view this content.

[gosbra]

Oh, man. I must be making a silly mistake?
I inserted the following function into a cell...

Please Login or Register  to view this content.

[AndyLitch]

I've tested it on my computer and it works ok using the following calling sub

Please Login or Register  to view this content.

so the function is basically OK.

Make sure that when you call the function you are inputting an array of data

[Norie]

I'm not sure the formula is meant to be used on a worksheet, or if it is not used in that way.

Try this, put the formula in G1, changing the reference E5:E11 to an absolute reference, which you can do with F4.

Copy the formula across a few columns, then select all the cells you've copied the formula to, goto the formula bar and then press CTRL+SHIFT+ENTER.

You should now see the unique values listed across the columns the formulas are in, and probably an #N/A or two.