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

=1
2
3
4
5
6
6
#N/A
#N/A
2
0
0
2
C2
2
C2


Probable a better way to do it, but this seems to work, could probable get it 
into a single cell, but would be a long formula. Using the Row 7 and 8 
method seems fine to figure which column, and then the row.

Numbers in A1C2; 
A3 - =MAX(A1:C2);
A4 - =MATCH(MAX($A$1:$C$2),A1:A2,0)0;
B4 - =MATCH(MAX($A$1:$C$2),B1:B2,0)0;
C4 - =MATCH(MAX($A$1:$C$2),C1:C2,0)0;
Finds which Column has Value and row; 
Row 5 used IFNA to set #N/A to 060;;
A5 - =IFNA(A4,0);
B5 - =IFNA(B4,0);
C5 - =IFNA(C4,0);
Row 6 creates Address<!
-- 
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