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 <[email protected]> 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: [email protected] > 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 -- To unsubscribe e-mail to: [email protected] 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
