Re: [libreoffice-users] How to return cell address/reference instead of function result with 2d operations?

Hey, this works! I need to analiyse slowly and thoroughly but there's a 
part I can't get into my head right from the start:
A1:C2=MAX(A1:C2)  <- what's that equal sign doing there? what does this 
part mean?

Thanks Tom

On the archive I saw someone else gave another working solution but I 
didn't get his replies on my inbox. Why? Are you getting my replies?

On 11/26/2015 09:26 AM, TomW wrote:
> On 2015-11-25 17:26, Edwar Cifuentes wrote:
> > Hi.
> >
> > When using functions like MAX on a 2d range how can I get the cell's 
> > address/reference returned instead of the result value?
> >
> > e.g. if I have this table starting at A1...
> > 1    2    3
> > 4    5    6
> >
> > How can I get this:
> > 1    2    3
> > 4    5    6
> > C2
> >
> > Instead of this:
> > 1    2    3
> > 4    5    6
> > 6
> >
> > I know I could something containing MATCH if it were just a single 
> > row or column but here I have a table spanning several rows and 
> > columns and there seems to be no equivalent of MATCH for these 
> > situations.
> >
> > Thank you
>
>
> Edwar:
>
> The following will find the address of the Max value.  If there are 
> duplicate values it shows the last location.
>
> =ADDRESS(MAX((A1:C2=MAX(A1:C2))*ROW(A1:C2)),MAX((A1:C2 = 
> MAX(A1:C2))*COLUMN(A1:C2)),4)
>
> This is an array function and you need to use Ctrl-Shift-Enter instead 
> of Enter.
>
> Hope this works for you,
>
> TomW


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted