Original posting of columns and rows got converted to single column. Also,
did some other adding of stuff, and lost the info on rows 7 and 8??
Columns A - C with 8 rows
==================
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 A1- C2
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 0
A5 - =IFNA(A4,0);
B5 - =IFNA(B4,0);
C5 - =IFNA(C4,0);
Row 6 creates Address
A6 - =IF(A5>0,"A","")&IF(B5>0,"B","")&IF(C5>0,"C","")&MAX(A5:C5)
Row 7 – Reduced need of extra Row
A7 - =IFNA(MATCH(MAX($A$1:$C$2),A1:A2,0),"")
B7 - =IFNA(MATCH(MAX($A$1:$C$2),B1:B2,0),"")
C7 - =IFNA(MATCH(MAX($A$1:$C$2),C1:C2,0),"")
Row 8 creates Address
A8 - =IF(A7<>"","A","")&IF(B7<>"","B","")&IF(C7<>"","C","")&MAX(A7:C7)
+----------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor
Guam Community College Computer Center
mailto:mi...@kuentos.guam.net
mailto:msetze...@gmail.com
http://www.guam.net/home/mikes
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+----------------------------------------------------------+
http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned: 19,471
Processing time: 32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)
BOINC@HOME CREDITS
ROSETTA 37225634.002678 | SETI 68310867.641544
ABC 16613838.513356 | EINSTEIN 79308287.225694
--
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
