I think you meant to write this:
=INDIRECT("$A"&MATCH(MIN(B*1*:B*4*);B*1*:B*4*;0))
Chuck
On Sun, Jan 24, 2021 at 3:22 PM Rob Jasper <[email protected]> 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]> 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.
> >
> >
> >
> > --
> > 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
>
>
--
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
