2016-06-25T07:16:38.437590147P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/a2c557d80ac68c06ea59586245a7431e061938f0 0 0 63260 82183 view1 1 8 0 0 0 0 2 0 0 0 0 0 75 60 true false 4 35 0 0 0 0 2 0 0 0 6 0 75 60 true false 3 108 0 0 0 0 2 0 0 0 81 0 75 60 true false winfrieds_testCase 1280 0 75 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true false 7 false false true true false false false 1270 1270 true true true true true false 12632256 false Lexmark-E352dn en US true true 3 1 true 1 true qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= false 0 Kč - Kč $ $( ) $- £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ Kč - Kč Kč - Kč Kč - Kč Kč - Kč € - € € - € € - € € - € - - € - € - € - - € - € - € : : : : $ ($ ) $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - Yes Yes No True True False On On Off € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - - - € - € . / € - € ⌀ $ - $ ( ) - $ $( ) $- ( ) - $ € - € . . / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) - ( ) - ( ) - ( ) - ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 AGGREGATE Function Result TRUE Sheet Result Description 1 TRUE Simple AGGREGATE formulas with local references and values TRUE Complete variations of AGGREGATE formulas with local references and values Function Expected Correct FunctionString Comment #DIV/0! 82 ColumnOne ColumnTwo ColumnThree 96 96 TRUE =AGGREGATE(4, 6, J2:J12) 72 65 34 11 12 72 72 TRUE =AGGREGATE(14, 6, J2:J12, 3) 30 95 10 56 35 13 Err:511 error TRUE =AGGREGATE(15, 6, J2:J12) #NUM! 63 #DIV/0! 5 3 34 34 TRUE =AGGREGATE(4,1,O2:O9) 31 53 20 8 1 5 29 29 TRUE =AGGREGATE(9,5,O5:Q5) 96 71 0 8 9 115 115 TRUE =AGGREGATE(9,5,P2:P9) 32 55 #VALUE! 20 21 8 8 TRUE =AGGREGATE(13,5,P2:P9) 81 83 5 7 8 14.375 14.375 TRUE =AGGREGATE(1,5,P2:P9) 33 100 14 0 5 8 8 TRUE =AGGREGATE(2,5,P2:P9) 53 91 8 8 TRUE =AGGREGATE(3,5,P2:P9) 34 89 56 56 TRUE =AGGREGATE(4,5,P2:P9) 0.00 0.00 TRUE =AGGREGATE(5,5,P2:P9) 0 0 TRUE =AGGREGATE(6,5,P2:P9) 17.7517604760767 TRUE TRUE =AGGREGATE(7,5,P2:P9) 16.6052514283886 TRUE TRUE =AGGREGATE(8,5,P2:P9) 115 115 TRUE =AGGREGATE(9,5,P2:P9) 315.125 315.125 TRUE =AGGREGATE(10,5,P2:P9) Function index Function applied Option index Option applied 275.734375 275.734375 TRUE =AGGREGATE(11,5,P2:P9) 1 AVERAGE 0 Ignore only nested SUBTOTAL and AGGREGATE functions 8 8 TRUE =AGGREGATE(12,5,P2:P9) 2 COUNT 1 Ignore only hidden rows, nested SUBTOTAL and AGGREGATE functions Err:511 error TRUE =AGGREGATE(14,5,P2:P9) 3 COUNTA 2 Ignore only errors, nested SUBTOTAL and AGGREGATE functions Err:511 error TRUE =AGGREGATE(15,5,P2:P9) 4 MAX 3 Ignore hidden rows, errors, nested SUBTOTAL and AGGREGATE functions Err:511 error TRUE =AGGREGATE(16,5,P2:P9) 5 MIN 4 Ignore nothing Err:511 error TRUE =AGGREGATE(17,5,P2:P9) 6 PRODUCT 5 Ignore only hidden rows Err:511 error TRUE =AGGREGATE(18,5,P2:P9) 7 STDEV.S 6 Ignore only errors Err:511 error TRUE =AGGREGATE(19,5,P2:P9) 8 STDEV.P 7 Ignore only hidden rows and errors 34 34 TRUE =AGGREGATE(4,5,O2:O9) 9 SUM 6 6 TRUE =AGGREGATE(2,2,O2:O9) 10 VAR.S 6 6 TRUE =AGGREGATE(2,0,O2:O9) 11 VAR.P 6 6 TRUE =AGGREGATE(2,1,O2:O9) 12 MEDIAN 6 6 TRUE =AGGREGATE(2,3,O2:O9) 13 MODE.SNGL 6 6 TRUE =AGGREGATE(2,4,O2:O9) 14 LARGE 6 6 TRUE =AGGREGATE(2,5,O2:O9) 15 SMALL 6 6 TRUE =AGGREGATE(2,6,O2:O9) 16 PERCENTILE.INC 6 6 TRUE =AGGREGATE(2,7,O2:O9) 17 QUARTILE.INC Err:502 error TRUE =AGGREGATE(2,8,O2:O9) 18 PERCENTILE.EXC Err:511 error TRUE =AGGREGATE(O2:O9) 19 QUARTILE.EXC #DIV/0! 82 Testcase from Bug 73148 - Add Excel 2010 function AGGREGATE 72 65 30 95 #VALUE! 63 31 -55555 96 71 33 55 #DIV/0! 83 0 100 53 91 34 89 #DIV/0! error TRUE =AGGREGATE( K$13,$J17,$C$1:$C$11) func.num 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 #DIV/0! error TRUE =AGGREGATE( K$13,$J18,$C$1:$C$11) func.name AVERAGE COUNT COUNTA MAX MIN PRODUCT STDEV.S STDEV.P SUM VAR.S VAR.P MEDIAN MODE.SNGL LARGE SMALL PERCENTILE.INC QUARTILE.INC PERCENTILE.EXC QUARTILE.EXC #DIV/0! error TRUE =AGGREGATE( K$13,$J19,$C$1:$C$11) 49.8571428571429 49.8571428571429 TRUE =AGGREGATE( K$13,$J20,$C$1:$C$11) option behaviour 42.1666666666667 42.1666666666667 TRUE =AGGREGATE( K$13,$J21,$C$1:$C$11) ignore nested SUBTOTAL/AGGREGATE #DIV/0! error TRUE =AGGREGATE( K$13,$J22,$C$1:$C$11) 0 ignore nested SUBTOTAL/AGGREGATE #DIV/0! error TRUE =AGGREGATE( K$13,$J23,$C$1:$C$11) 1 ignore hidden rows, nested SUBTOTAL/AGGREGATE 43.625 43.625 TRUE =AGGREGATE( K$13,$J24,$C$1:$C$11) 2 ignore error values, nested SUBTOTAL/AGGREGATE 36.1428571428571 36.1428571428571 TRUE =AGGREGATE( K$13,$J25,$C$1:$C$11) 3 ignore hidden rows, error values, nested SUBTOTAL/AGGREGATE 7 7 TRUE =AGGREGATE( L$13,$J17,$C$1:$C$11) 4 ignore nothing 7 7 TRUE =AGGREGATE( L$13,$J18,$C$1:$C$11) 5 ignore hidden rows 6 6 TRUE =AGGREGATE( L$13,$J19,$C$1:$C$11) 6 ignore error values 7 7 TRUE =AGGREGATE( L$13,$J20,$C$1:$C$11) 7 ignore hidden rows, error values 6 6 TRUE =AGGREGATE( L$13,$J21,$C$1:$C$11) 8 8 TRUE =AGGREGATE( L$13,$J22,$C$1:$C$11) 7 7 TRUE =AGGREGATE( L$13,$J23,$C$1:$C$11) 8 8 TRUE =AGGREGATE( L$13,$J24,$C$1:$C$11) 7 7 TRUE =AGGREGATE( L$13,$J25,$C$1:$C$11) 9 9 TRUE =AGGREGATE( M$13,$J17,$C$1:$C$11) 9 9 TRUE =AGGREGATE( M$13,$J18,$C$1:$C$11) 8 8 TRUE =AGGREGATE( M$13,$J19,$C$1:$C$11) 7 7 TRUE =AGGREGATE( M$13,$J20,$C$1:$C$11) 6 6 TRUE =AGGREGATE( M$13,$J21,$C$1:$C$11) 11 11 TRUE =AGGREGATE( M$13,$J22,$C$1:$C$11) 10 10 TRUE =AGGREGATE( M$13,$J23,$C$1:$C$11) 8 8 TRUE =AGGREGATE( M$13,$J24,$C$1:$C$11) 7 7 TRUE =AGGREGATE( M$13,$J25,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( N$13,$J17,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( N$13,$J18,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( N$13,$J19,$C$1:$C$11) 96 96 TRUE =AGGREGATE( N$13,$J20,$C$1:$C$11) 72 72 TRUE =AGGREGATE( N$13,$J21,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( N$13,$J22,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( N$13,$J23,$C$1:$C$11) 96 96 TRUE =AGGREGATE( N$13,$J24,$C$1:$C$11) 72 72 TRUE =AGGREGATE( N$13,$J25,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( O$13,$J17,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( O$13,$J18,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( O$13,$J19,$C$1:$C$11) 30 30 TRUE =AGGREGATE( O$13,$J20,$C$1:$C$11) 30 30 TRUE =AGGREGATE( O$13,$J21,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( O$13,$J22,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( O$13,$J23,$C$1:$C$11) 0 0 TRUE =AGGREGATE( O$13,$J24,$C$1:$C$11) 0 0 TRUE =AGGREGATE( O$13,$J25,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( P$13,$J17,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( P$13,$J18,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( P$13,$J19,$C$1:$C$11) 382256962560 382256962560 TRUE =AGGREGATE( P$13,$J20,$C$1:$C$11) 3981843360 3981843360 TRUE =AGGREGATE( P$13,$J21,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( P$13,$J22,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( P$13,$J23,$C$1:$C$11) 0 0 TRUE =AGGREGATE( P$13,$J24,$C$1:$C$11) 0 0 TRUE =AGGREGATE( P$13,$J25,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( Q$13,$J17,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( Q$13,$J18,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( Q$13,$J19,$C$1:$C$11) 25.5436134968448 25.5436134968448 TRUE =AGGREGATE( Q$13,$J20,$C$1:$C$11) 16.9164614109058 16.9164614109058 TRUE =AGGREGATE( Q$13,$J21,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( Q$13,$J22,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( Q$13,$J23,$C$1:$C$11) 29.4954596990307 29.4954596990307 TRUE =AGGREGATE( Q$13,$J24,$C$1:$C$11) 22.1918045790826 22.1918045790826 TRUE =AGGREGATE( Q$13,$J25,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( R$13,$J17,$C$1:$C$11) STDEV.P empty second parameter #DIV/0! error TRUE =AGGREGATE( R$13,$J18,$C$1:$C$11) Tdf#100753 #DIV/0! error TRUE =AGGREGATE( R$13,$J19,$C$1:$C$11) YELLOW ROWS THROWS ERROR IN EXCEL 23.6487907962003 23.6487907962003 TRUE =AGGREGATE( R$13,$J20,$C$1:$C$11) 15.4425458465313 15.4425458465313 TRUE =AGGREGATE( R$13,$J21,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( R$13,$J22,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( R$13,$J23,$C$1:$C$11) 27.5904761647928 27.5904761647928 TRUE =AGGREGATE( R$13,$J24,$C$1:$C$11) 20.5456187295392 20.5456187295392 TRUE =AGGREGATE( R$13,$J25,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( S$13,$J17,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( S$13,$J18,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( S$13,$J19,$C$1:$C$11) 349 349 TRUE =AGGREGATE( S$13,$J20,$C$1:$C$11) 253 253 TRUE =AGGREGATE( S$13,$J21,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( S$13,$J22,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( S$13,$J23,$C$1:$C$11) 349 349 TRUE =AGGREGATE( S$13,$J24,$C$1:$C$11) 253 253 TRUE =AGGREGATE( S$13,$J25,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( T$13,$J17,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( T$13,$J18,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( T$13,$J19,$C$1:$C$11) 652.476190476191 652.476190476191 TRUE =AGGREGATE( T$13,$J20,$C$1:$C$11) 286.166666666667 286.166666666667 TRUE =AGGREGATE( T$13,$J21,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( T$13,$J22,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( T$13,$J23,$C$1:$C$11) 869.982142857143 869.982142857143 TRUE =AGGREGATE( T$13,$J24,$C$1:$C$11) 492.476190476191 492.476190476191 TRUE =AGGREGATE( T$13,$J25,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( U$13,$J17,$C$1:$C$11) VAR.P #DIV/0! #DIV/0! error TRUE =AGGREGATE( U$13,$J18,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( U$13,$J19,$C$1:$C$11) 559.265306122449 559.265306122449 TRUE =AGGREGATE( U$13,$J20,$C$1:$C$11) 238.472222222222 238.472222222222 TRUE =AGGREGATE( U$13,$J21,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( U$13,$J22,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( U$13,$J23,$C$1:$C$11) 761.234375 761.234375 TRUE =AGGREGATE( U$13,$J24,$C$1:$C$11) 422.122448979592 422.122448979592 TRUE =AGGREGATE( U$13,$J25,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( V$13,$J17,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( V$13,$J18,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( V$13,$J19,$C$1:$C$11) 34 34 TRUE =AGGREGATE( V$13,$J20,$C$1:$C$11) 33.5 33.5 TRUE =AGGREGATE( V$13,$J21,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( V$13,$J22,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( V$13,$J23,$C$1:$C$11) 33.5 33.5 TRUE =AGGREGATE( V$13,$J24,$C$1:$C$11) 33 33 TRUE =AGGREGATE( V$13,$J25,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( W$13,$J17,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( W$13,$J18,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( W$13,$J19,$C$1:$C$11) #VALUE! error TRUE =AGGREGATE( W$13,$J20,$C$1:$C$11) #VALUE! error TRUE =AGGREGATE( W$13,$J21,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( W$13,$J22,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( W$13,$J23,$C$1:$C$11) #VALUE! error TRUE =AGGREGATE( W$13,$J24,$C$1:$C$11) #VALUE! error TRUE =AGGREGATE( W$13,$J25,$C$1:$C$11) #DIV/0! error TRUE =AGGREGATE( X$13,$J17,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( X$13,$J18,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( X$13,$J19,$C$1:$C$11,2) 72 72 TRUE =AGGREGATE( X$13,$J20,$C$1:$C$11,2) 53 53 TRUE =AGGREGATE( X$13,$J21,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( X$13,$J22,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( X$13,$J23,$C$1:$C$11,2) 72 72 TRUE =AGGREGATE( X$13,$J24,$C$1:$C$11,2) 53 53 TRUE =AGGREGATE( X$13,$J25,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( Y$13,$J17,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( Y$13,$J18,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( Y$13,$J19,$C$1:$C$11,2) 31 31 TRUE =AGGREGATE( Y$13,$J20,$C$1:$C$11,2) 31 31 TRUE =AGGREGATE( Y$13,$J21,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( Y$13,$J22,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( Y$13,$J23,$C$1:$C$11,2) 30 30 TRUE =AGGREGATE( Y$13,$J24,$C$1:$C$11,2) 30 30 TRUE =AGGREGATE( Y$13,$J25,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( Z$13,$J17,$C$1:$C$11,0) #DIV/0! error TRUE =AGGREGATE( Z$13,$J18,$C$1:$C$11,0) #DIV/0! error TRUE =AGGREGATE( Z$13,$J19,$C$1:$C$11,0) 30 30 TRUE =AGGREGATE( Z$13,$J20,$C$1:$C$11,0) 30 30 TRUE =AGGREGATE( Z$13,$J21,$C$1:$C$11,0) #DIV/0! error TRUE =AGGREGATE( Z$13,$J22,$C$1:$C$11,0) #DIV/0! error TRUE =AGGREGATE( Z$13,$J23,$C$1:$C$11,0) 0 0 TRUE =AGGREGATE( Z$13,$J24,$C$1:$C$11,0) 0 0 TRUE =AGGREGATE( Z$13,$J25,$C$1:$C$11,0) #DIV/0! error TRUE =AGGREGATE( AA$13,$J17,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( AA$13,$J18,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( AA$13,$J19,$C$1:$C$11,2) 34 34 TRUE =AGGREGATE( AA$13,$J20,$C$1:$C$11,2) 33.5 33.5 TRUE =AGGREGATE( AA$13,$J21,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( AA$13,$J22,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( AA$13,$J23,$C$1:$C$11,2) 33.5 33.5 TRUE =AGGREGATE( AA$13,$J24,$C$1:$C$11,2) 33 33 TRUE =AGGREGATE( AA$13,$J25,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( AB$13,$J17,$C$1:$C$11,0.3) #DIV/0! error TRUE =AGGREGATE( AB$13,$J18,$C$1:$C$11,0.3) #DIV/0! error TRUE =AGGREGATE( AB$13,$J19,$C$1:$C$11,0.3) 31.8 31.8 TRUE =AGGREGATE( AB$13,$J20,$C$1:$C$11,0.3) 31.2 31.2 TRUE =AGGREGATE( AB$13,$J21,$C$1:$C$11,0.3) #DIV/0! error TRUE =AGGREGATE( AB$13,$J22,$C$1:$C$11,0.3) #DIV/0! error TRUE =AGGREGATE( AB$13,$J23,$C$1:$C$11,0.3) 30.7 30.7 TRUE =AGGREGATE( AB$13,$J24,$C$1:$C$11,0.3) 30.4 30.4 TRUE =AGGREGATE( AB$13,$J25,$C$1:$C$11,0.3) #DIV/0! error TRUE =AGGREGATE( AC$13,$J17,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( AC$13,$J18,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( AC$13,$J19,$C$1:$C$11,2) 34 34 TRUE =AGGREGATE( AC$13,$J20,$C$1:$C$11,2) 33.5 33.5 TRUE =AGGREGATE( AC$13,$J21,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( AC$13,$J22,$C$1:$C$11,2) #DIV/0! error TRUE =AGGREGATE( AC$13,$J23,$C$1:$C$11,2) 33.5 33.5 TRUE =AGGREGATE( AC$13,$J24,$C$1:$C$11,2) 33 33 TRUE =AGGREGATE( AC$13,$J25,$C$1:$C$11,2) 0 0 TRUE =AGGREGATE(3,5,$C$6) tdf116706 0 0 TRUE =AGGREGATE(3,5,$C$6:$C$6) tdf116706 4 O5