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
-- 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