Re: [libreoffice-users] calc: index column A with column B

Then use >0.0000001 or whatever value works instead of >0


On 29 Jan 2021 at 14:06, James wrote:

Subject:                Re: [libreoffice-users] calc: index column A with 
column B
To:                     Rob Jasper <Rob@famjasper.nl>
Copies to:              users@global.libreoffice.org
From:                   James <bjlockie@lockie.ca>
Date sent:              Fri, 29 Jan 2021 14:06:08 -0500

> Another problem.
>
> Some of the numbers display as 0 but are calculated so have fractions like
>
> 0.0000000812344372353
> I want to find the last row that displays as non-zero.        
>       
>
> On 2021-01-29 6:30 a.m., Rob Jasper wrote
>
> > James,
> >
> > Since a MINIF function does not exist you can use MINIFS.
> >
> > Change MIN(B:B) to MINIFS(B:B;B:B;">0")
> >
> > Success,
> > Rob
> >
> >
> > > Op 29 jan. 2021, om 03:59 heeft James <bjlockie@lockie.ca> het volgende geschreven:
> > >
> > > >     I want to find the row in column A that corresponds to the row of a
> > > >
> > > > value in column B.
> > > >
> > > >     eg.
> > > >
> > > >     row    A        B
> > > >     1      10       220000
> > > >     2      20       150000
> > > >     3      30       3000
> > > >     4      40       10
> > > >
> > > >     =some_function('A',minimum_function(B));
> > > >
> > > >     where minimum_function(B) returns 4 and some_function('A',4) returns the
> > > >
> > > > value in column A at row 4.
> > > I asked the previous and someone gave me the formula:
> > >
> > > =INDIRECT("$A"&MATCH(MIN(B:B);B:B;0))
> > >
> > >
> > > It worked fine but now I have some rows with zeros (more than one row):
> > > row        A       B
> > > 1       10      220000
> > > 2       20      150000
> > > 3       30      3000
> > > 4       40      10
> > > 5  50      0
> > > 6  60      0
> > >
> > > Is there a MINBUTGREATERTHANZERO function?
>
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy


+------------------------------------------------------------+
 Michael D. Setzer II - Computer Science Instructor (Retired)     
 mailto:mikes@guam.net                            
 mailto:msetzerii@gmail.com
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy