Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie: pisy_rasfatata la Simpatie.ro
| Femeie 23 ani Bucuresti cauta Barbat 23 - 55 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2186
|
|
Finding and coloring the top / bottom 10 (or more/less) values in a range or an array is easily done with Conditional Formatting - New Rule - Format only top or bottom ranked values.
But to actually extract those values from a range / array you would need a formula. The following is an array formula so make sure you enter it with CTRL+SHIFT+ENTER.
For example, I wanted the top 14 values in an array and I used: =LARGE($C$3:$H$1836;{1;2;3;4;5;6;7;8;9;10;11;12;13;14})
But in order for this to work, you first must select the number of desired cells (in my case 14 cells, I selected S1:S14, and with those cells selected add the formula above and hit CTRL+SHIFT+ENTER.
Source:
_______________________________________
|
|
pus acum 5 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2186
|
|
To find the nth largest number you could also use the AGGREGATE function, see more info here:
=AGGREGATE(14;6,values;1) // 1st largest =AGGREGATE(14;6,values;2) // 2nd largest =AGGREGATE(14;6,values;3) // 3rd largest etc.
_______________________________________
|
|
pus acum 4 ani |
|