0

Unique names

Jet Reports Historic Posts

March 19, 2012 21:10

None

Follow

Hi,


I've got a list with Projectelements.
=NL("Rijen";"Projectvoorraadpost";"Element";"Projectnr.";$D9;"Entiteittype";$E$4;"Boekingssoort";$E$5&"|"&$E$6)For example:
A.01.P
A.01.M
B.02.P
B.03.P
B.03.M

Now I want a unique list from this projectelement, but only for the first 4 characters
So the result has to be:

A.01
B.02
B.03

Who's have an idea to make this?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts March 23, 2012 05:19

  Probeer eens
  
  NL("Rijen";"Projectvoorraadpost";"=LINKS(NF(;""Element"");4)";"Projectnr.";$D9;"Entiteittype";$E$4;"Boekingssoort";$E$5&"|"&$E$6)