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+unsubscr...@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

Reply via email to