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

James,
There are 2 basic ways to accomplish this:

Round the values at calculation time, so they’ll become real 0’s

Change the formula to MINIFS(B:B;B:B;">=1”)

Success,
Rob

> Op 29 jan. 2021, om 20:06 heeft James <bjlockie@lockie.ca> het volgende geschreven:
>
> 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> <mailto: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