Re: Multiple column filter

2019-03-01 Thread Sudha Bharathan
Martin Thanks a lot ...it's solved... thanks Regards, Sudha Bharathan On Fri, 1 Mar, 2019, 8:45 PM Martin Groenescheij, wrote: > I mean > > Try filter 1: F = Irity > AND 2: N = 0 > OR3: F = Irity > AND 4: N = 10 > > > > > On 1 Mar 2019, at 16:13, Martin Groenescheij > w

Re: Multiple column filter

2019-03-01 Thread Brian Barker
At 17:50 01/03/2019 +0530, Sudha Bharathan wrote: I am unable to get the desired result ... I don't read minds: it would help if you explained what is your desired result! ... after the third filter is added on open office calc.(open office 4.1.6) 1. filter in column F 2.filter in column N 3.

Re: Multiple column filter

2019-03-01 Thread Martin Groenescheij
I mean > Try filter 1: F = Irity > AND 2: N = 0 > OR3: F = Irity > AND 4: N = 10 > On 1 Mar 2019, at 16:13, Martin Groenescheij wrote: > > Try filter 1: F = Irity > 2: N = 0 > 3: F = Irity > 4: N = 10 > > > >> On 1 Mar 20

Re: Multiple column filter

2019-03-01 Thread Martin Groenescheij
Try filter 1: F = Irity 2: N = 0 3: F = Irity 4: N = 10 > On 1 Mar 2019, at 13:20, Sudha Bharathan wrote: > > Hi > I am unable to get the desired result after the third filter is added on open > office calc.(open office 4.1.6) > 1. filter in col

Re: Multiple column filter

2019-03-01 Thread Wade Smart
Hmmm I am wrong. I can get either 0 or 10 but not both. I had mistyped when I looked at my sample data. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Fri, Mar 1, 2019 at 8:37 AM Wade Smart wrote: > > I just recreated your list and without formatting

Re: Multiple column filter

2019-03-01 Thread Wade Smart
I just recreated your list and without formatting, it worked fine. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 > I had understood what you meant..It is formatted as number and not text. > > Regards, > > Sudha Bharathan ---

Re: Multiple column filter

2019-03-01 Thread Sudha Bharathan
Hi I had understood what you meant..It is formatted as number and not text. Regards, Sudha Bharathan On Fri, 1 Mar, 2019, 7:20 PM Wade Smart, wrote: > Sorry, that wasnt clear on my part, > is the cell formatted to number or text? > -- > Registered Linux User: #480675 > Registered Linux Machin

Re: Multiple column filter

2019-03-01 Thread Wade Smart
Sorry, that wasnt clear on my part, is the cell formatted to number or text? -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Fri, Mar 1, 2019 at 7:30 AM Sudha Bharathan wrote: > 10 is a number not text > > On Fri, Mar 1, 2019 at 6:31 PM Wade Smart

Re: Multiple column filter

2019-03-01 Thread Sudha Bharathan
10 is a number not text On Fri, Mar 1, 2019 at 6:31 PM Wade Smart wrote: > Is 10 a number or is it formatted as text? > -- > Registered Linux User: #480675 > Registered Linux Machine: #408606 > Linux since June 2005 > > > On Fri, Mar 1, 2019 at 6:29 AM Sudha Bharathan > wrote: > >> Hi >> I am u

Re: Multiple column filter

2019-03-01 Thread Wade Smart
Is 10 a number or is it formatted as text? -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Fri, Mar 1, 2019 at 6:29 AM Sudha Bharathan wrote: > Hi > I am unable to get the desired result after the third filter is added on > open office calc.(open of