=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: [email protected] 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
