0

Filter item list with numbers and text

Jet Reports Historic Posts

December 22, 2010 21:18

None

Follow

I want to put a filter in a NL function on a part list. I only want to find the parts who have a numeric no. and exclude the parts with a alphabetic no.
Can sombody help me please?
"07128963354" is ok and "AT-071289633" not ok.

Thx.

J-F

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts December 23, 2010 07:35 Official comment

  How about this
  
  =NL("Rows";"Item";;"No.";"=IF(ISERROR(VALUE(NF(;""No."")))=FALSE;NF(;""No.""))")
  Does this do the trick for you?

• 0
  
  Jet Reports Historic Posts December 23, 2010 22:24

  Hans
  
  Neat solution !!!