Great, thanks. On 2021-01-24 5:59 p.m., Rob Jasper wrote:
Is this what you mean:=INDIRECT("$A"&MATCH(MIN(B:B);B:B;0))Op 24 jan. 2021, om 23:14 heeft James <[email protected] <mailto:[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 AB 1 10220000 2 20150000 3 303000 4 4010 =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.--To unsubscribe e-mail to: [email protected] <mailto:[email protected]> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ <https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette <https://wiki.documentfoundation.org/Netiquette> List archive: https://listarchives.libreoffice.org/global/users/ <https://listarchives.libreoffice.org/global/users/> Privacy Policy: https://www.documentfoundation.org/privacy <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
