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 <r...@famjasper.nl>
Copies to: users@global.libreoffice.org
From: James <bjloc...@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 <bjloc...@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+unsubscr...@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:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+
--
To unsubscribe e-mail to: users+unsubscr...@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
