| Line 1: |
Line 1: |
| − | topn
| + | <div style="font-size:30px">'''TOPN (Array,n)'''</div><br/> |
| | + | *<math>Array</math> is the set of numbers. |
| | + | *<math>n</math> is the number. |
| | + | |
| | + | ==Description== |
| | + | *This function shows the starting 'n' values of the given array. |
| | + | *In <math>TOPN(Array,n)</math>,<math>Array</math> is the set of values and <math>n</math> is the number of the value. |
| | + | *<math>TOPN</math> shows the first 'n' values from the given set of values. |
| | + | |
| | + | ==Examples== |
| | + | #TOPN([20,13,17,19,22,26,32,56,45,10,98,112,134,201],6) = 20 13 17 19 22 26 |
| | + | #TOPN([1.2,8.001,2.8,10,4.001,6,2],0) = 1.2 |
| | + | #TOPN([100,12,31,89,12,17,19],10)= 100 12 31 89 12 17 19 |
| | + | |
| | + | ==See Also== |
| | + | *[[Manuals/calci/LOWER | LOWER ]] |
| | + | *[[Manuals/calci/UPPER | UPPER]] |
| | + | *[[Manuals/calci/SMALLLETTERS | SMALLLETTERS ]] |
| | + | |
| | + | ==References== |
| | + | [http://www.thetoptens.com/top-ten-greatest-numbers/ Top] |