0

Jet Report filter based on excel list

Jet Reports Historic Posts

November 24, 2011 21:09

None

Follow

Hello,

Is there any way to create a filter based on a list of many cells separated with the "OR" functionality?

For example:

In Excel I have
A1 = one
A2 = two
A3 = three
A4 = four
:
:
A100 = onehundred

How do I specify the following in a Jet Filter? A1|A2|A3 all the way to A100 ???

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts November 25, 2011 07:53 Official comment

  NP("Join",A1:A100,"|")

• 0
  
  Jet Reports Historic Posts November 25, 2011 18:24

  Thank You Very Much, it worked!