0

How to list out Unique data

Jean Gasser

December 19, 2017 10:57

None

Follow

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?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Harry Lewis December 20, 2017 16:21

  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.