Spreadsheet: 863845d1711226447-position-each-value-found-in-each-line-of-a-table-under-its-competent-tens-group-curiosit-statistica
Sheet: Foglio1

 |  | EXCEL used: OFFICE 2021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01 ==========================> 09 |  |  |  |  |  |  |  |  |  |  | 10 ==========================> 19 |  |  |  |  |  |  |  |  |  | 20 ==========================> 29 |  |  |  |  |  |  |  |  |  | 30 ==========================> 39 |  |  |  |  |  |  |  |  |  | 40 ==========================> 49 |  |  |  |  |  |  |  |  |  | 50 ==========================> 59 |  |  |  |  |  |  |  |  |  | 60 ==========================> 69 |  |  |  |  |  |  |  |  |  | 70 ==========================>79 |  |  |  |  |  |  |  |  |  | 80 ==========================> 89 |  |  |  |  |  |  |  |  |  | 90
 | 7 | 9 | 15 | 16 | 23 | 24 | 34 | 35 | 36 | 37 | 46 | 50 | 53 | 56 | 70 | 73 | 83 | 84 | 86 | 90 |  |  |  |  | 7 | 9 |  |  |  |  |  |  |  |  |  | 15 | 16 |  |  |  |  |  |  |  |  | 23 | 24 |  |  |  |  |  |  |  |  | 34 | 35 | 36 | 37 |  |  |  |  |  |  | 46 |  |  |  |  |  |  |  |  |  | 50 | 53 | 56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | 73 |  |  |  |  |  |  |  |  | 83 | 84 | 86 |  |  |  |  |  |  |  | 90
 | 19 | 20 | 26 | 27 | 33 | 35 | 37 | 41 | 46 | 47 | 48 | 52 | 54 | 58 | 70 | 71 | 76 | 82 | 85 | 89 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 |  |  |  |  |  |  |  |  |  | 20 | 26 | 27 |  |  |  |  |  |  |  | 33 | 35 | 37 |  |  |  |  |  |  |  | 41 | 46 | 47 | 48 |  |  |  |  |  |  | 52 | 54 | 58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | 71 | 76 |  |  |  |  |  |  |  | 82 | 85 | 89
 | 6 | 8 | 9 | 12 | 13 | 17 | 23 | 32 | 43 | 52 | 57 | 58 | 59 | 65 | 66 | 71 | 73 | 78 | 87 | 89
 | 1 | 5 | 10 | 15 | 20 | 33 | 35 | 39 | 42 | 46 | 48 | 51 | 52 | 56 | 61 | 62 | 72 | 83 | 85 | 87
 | 1 | 13 | 18 | 23 | 24 | 30 | 33 | 44 | 47 | 48 | 51 | 61 | 63 | 79 | 80 | 83 | 85 | 86 | 87 | 89
 | 16 | 17 | 23 | 25 | 28 | 31 | 33 | 36 | 38 | 39 | 56 | 57 | 64 | 67 | 68 | 69 | 76 | 79 | 87 | 89 |  |  |  |  | IT- COSA si vorrebbe:
 | 5 | 12 | 20 | 25 | 27 | 30 | 32 | 35 | 41 | 45 | 46 | 51 | 55 | 58 | 63 | 70 | 72 | 73 | 74 | 88 |  |  |  |  |  | Per ogni singola riga contenente valori univoci ordinati
 | 5 | 14 | 16 | 19 | 21 | 28 | 32 | 33 | 34 | 36 | 40 | 45 | 48 | 55 | 57 | 59 | 69 | 78 | 86 | 90 |  |  |  |  |  | inscatolare ognuno dei valori sotto la propria decina di appartenenza.
 | 14 | 16 | 19 | 23 | 26 | 30 | 39 | 45 | 46 | 47 | 56 | 57 | 59 | 60 | 61 | 68 | 71 | 78 | 87 | 90
 | 4 | 5 | 7 | 8 | 13 | 21 | 23 | 38 | 42 | 45 | 46 | 48 | 52 | 55 | 62 | 67 | 68 | 73 | 79 | 80 |  |  |  |  | EN- what is whished:
 | 1 | 7 | 9 | 12 | 14 | 22 | 39 | 40 | 42 | 53 | 56 | 61 | 64 | 70 | 71 | 76 | 81 | 82 | 85 | 86 |  |  |  |  |  | Position each value found in each line of the table under its competent tens group
 | 5 | 6 | 7 | 10 | 24 | 25 | 32 | 38 | 40 | 41 | 43 | 60 | 76 | 77 | 78 | 80 | 84 | 87 | 88 | 90
 | 3 | 5 | 12 | 22 | 26 | 27 | 33 | 39 | 43 | 46 | 51 | 55 | 58 | 72 | 74 | 75 | 81 | 82 | 89 | 90
 | 1 | 4 | 10 | 13 | 14 | 15 | 25 | 34 | 40 | 45 | 46 | 53 | 57 | 59 | 60 | 63 | 64 | 83 | 86 | 87
 | 2 | 3 | 4 | 7 | 9 | 14 | 27 | 31 | 33 | 42 | 59 | 67 | 73 | 75 | 76 | 78 | 79 | 80 | 81 | 90 |  |  |  |  | Qui di seguito , alla riga 23,
 | 4 | 6 | 7 | 14 | 15 | 20 | 26 | 28 | 39 | 48 | 53 | 63 | 65 | 69 | 72 | 74 | 76 | 82 | 85 | 89 |  |  |  |  |  | Tentativo di soluzione con =[NAME]:U20;AK1:AK20<B23)
 | 13 | 16 | 23 | 25 | 27 | 28 | 30 | 34 | 42 | 45 | 50 | 57 | 63 | 66 | 69 | 70 | 73 | 76 | 77 | 89
 | 1 | 4 | 9 | 12 | 23 | 24 | 25 | 26 | 44 | 47 | 57 | 58 | 64 | 73 | 75 | 76 | 80 | 81 | 85 | 89 |  |  |  |  | In raw 23,
 | 1 | 9 | 10 | 16 | 24 | 28 | 32 | 36 | 46 | 47 | 54 | 57 | 60 | 65 | 67 | 71 | 72 | 74 | 75 | 80 |  |  |  |  |  | own attempted solution using =[NAME]:U20;AK1:AK20<B23)
 | Tentativo di soluzione con =[NAME]:U20;AK1:AK20<B23)
 | 10 |  | 9 | 15 | 16 | 23 | 24 | 34 | 35 | 36 | 37 | 46 | 50 | 53 | 56 | 70 | 73 | 83 | 84 | 86 | 90
 |  | 19 | 20 | 26 | 27 | 33 | 35 | 37 | 41 | 46 | 47 | 48 | 52 | 54 | 58 | 70 | 71 | 76 | 82 | 85 | 89
 |  | 6 | 8 | 9 | 12 | 13 | 17 | 23 | 32 | 43 | 52 | 57 | 58 | 59 | 65 | 66 | 71 | 73 | 78 | 87 | 89
 |  | 1 | 5 | 10 | 15 | 20 | 33 | 35 | 39 | 42 | 46 | 48 | 51 | 52 | 56 | 61 | 62 | 72 | 83 | 85 | 87
 |  | 1 | 13 | 18 | 23 | 24 | 30 | 33 | 44 | 47 | 48 | 51 | 61 | 63 | 79 | 80 | 83 | 85 | 86 | 87 | 89
 |  | 16 | 17 | 23 | 25 | 28 | 31 | 33 | 36 | 38 | 39 | 56 | 57 | 64 | 67 | 68 | 69 | 76 | 79 | 87 | 89
 |  | 5 | 12 | 20 | 25 | 27 | 30 | 32 | 35 | 41 | 45 | 46 | 51 | 55 | 58 | 63 | 70 | 72 | 73 | 74 | 88
 |  | 5 | 14 | 16 | 19 | 21 | 28 | 32 | 33 | 34 | 36 | 40 | 45 | 48 | 55 | 57 | 59 | 69 | 78 | 86 | 90
 |  | 14 | 16 | 19 | 23 | 26 | 30 | 39 | 45 | 46 | 47 | 56 | 57 | 59 | 60 | 61 | 68 | 71 | 78 | 87 | 90
 |  | 4 | 5 | 7 | 8 | 13 | 21 | 23 | 38 | 42 | 45 | 46 | 48 | 52 | 55 | 62 | 67 | 68 | 73 | 79 | 80
 |  | 1 | 7 | 9 | 12 | 14 | 22 | 39 | 40 | 42 | 53 | 56 | 61 | 64 | 70 | 71 | 76 | 81 | 82 | 85 | 86
 |  | 5 | 6 | 7 | 10 | 24 | 25 | 32 | 38 | 40 | 41 | 43 | 60 | 76 | 77 | 78 | 80 | 84 | 87 | 88 | 90
 |  | 3 | 5 | 12 | 22 | 26 | 27 | 33 | 39 | 43 | 46 | 51 | 55 | 58 | 72 | 74 | 75 | 81 | 82 | 89 | 90
 |  | 1 | 4 | 10 | 13 | 14 | 15 | 25 | 34 | 40 | 45 | 46 | 53 | 57 | 59 | 60 | 63 | 64 | 83 | 86 | 87
 |  | 2 | 3 | 4 | 7 | 9 | 14 | 27 | 31 | 33 | 42 | 59 | 67 | 73 | 75 | 76 | 78 | 79 | 80 | 81 | 90
 |  | 4 | 6 | 7 | 14 | 15 | 20 | 26 | 28 | 39 | 48 | 53 | 63 | 65 | 69 | 72 | 74 | 76 | 82 | 85 | 89
 |  | 13 | 16 | 23 | 25 | 27 | 28 | 30 | 34 | 42 | 45 | 50 | 57 | 63 | 66 | 69 | 70 | 73 | 76 | 77 | 89
 |  | 1 | 4 | 9 | 12 | 23 | 24 | 25 | 26 | 44 | 47 | 57 | 58 | 64 | 73 | 75 | 76 | 80 | 81 | 85 | 89
 |  | 1 | 9 | 10 | 16 | 24 | 28 | 32 | 36 | 46 | 47 | 54 | 57 | 60 | 65 | 67 | 71 | 72 | 74 | 75 | 80