Hello,
Attached my example.
Could you please send the solution?
See me below my test.
Thank you in advance
Regards
Jean
PS:
Is it not possible to attach the Excel JR template?
Date
Votes
1 comment
-
Harry Lewis Since the values returned by the Jet "array functions" { NP(Union), NP(Difference), and NP(Intersect) } are guaranteed to be unique, we can take advantage of that to achieve this.
Here is my example:
Were "MyData" is my named range.
You can see that I'm using the NP(Union) function.
When I run it...
I get only the unique values from that range.
Please sign in to leave a comment.