Re: [libreoffice-users] calc: index column A with column B

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 <Rob@famjasper.nl> 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> 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: 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

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