Using "operators" in "match function

[#1]

I would like to filter from a listbox, values, say between 5 to 10.

values
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

I know i probably have to drag the desired selection manually.

However, there is another function, with the formula if(match(values, 5,6,7,8,9,10), values)

values

5

6

7

8

9

10

How can i use an operator such as <=10 and >=5 to achieve the above?

something like this:

if(match(values, between (5,10), values)

What are the functions for matching values "between", "more than" and "less than" also?

thanks!

[rwunderlich]

Where do you want to do this filtering. In a Set Analysis expression? Or an Action?

-Rob

[#3]

i have created a list box.  this values are in listbox.

[Sokkorn]

Hi superida,

May be this one you looking for.

1. Click search icon in your List Box

2. Type >=5<=10

3. Hit enter key to filter value from List Box

See sample here

Regards,

Sokkorn

[#5]

Oh! great! thanks. 

Sorry i have another slight variation.  If i want to search for values that occur >5 times...

Values	Frequency
1	1
2	2
3	1
4	5
5	5
6	5
7	10
8	5
9	5
10	5

I had initially aske that question as i thought match function would do the trick. 

So, for listbox, with frequencies of occurence, how can i filter those with a certain frequency?

thanks!

[kumarnatarajan]

Hi,

Try this.

Ex:

=Aggr(Sum({$<Value={">=$(=Min(Value)) <=$(=max(Value))"}>}Value),Value)

Find the attached file.

[AbhijitBansode]

you can filter values like below:

[Sokkorn]

Hi superida,

Can you share business case that you trying to filter value by frequency?

Regards,

Sokkorn

[#9]

Thanks!  Possible to give the formula for between?

[AbhijitBansode]

could be like this:

Regards,

Abhijit