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
