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 <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 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: users+unsubscribe@global.libreoffice.org <mailto:users+unsubscribe@global.libreoffice.org> 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: 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