First, Second, 3rd, 4th, 5th, 6th most repeated TEXT

GESTIONCULTURA

New Member
Joined
May 1, 2014
Messages
7
[TABLE="width: 161"]
<colgroup><col></colgroup><tbody>[TR]
[TD]I didn't find any formula to return most common text from 1st to 101th or even more places. ALWAYS DATA IN VERTICAL COLUMN

SIMPLY AS POSSIBLE[/TD]
[/TR]
[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 161"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Naturaleza asociada[/TD]
[/TR]
[TR]
[TD]ÁRBOLES FRONDOSOS [/TD]
[/TR]
[TR]
[TD]JARDINES[/TD]
[/TR]
[TR]
[TD]SOMBRA[/TD]
[/TR]
[TR]
[TD]FRESCO[/TD]
[/TR]
[TR]
[TD]VERDE[/TD]
[/TR]
[TR]
[TD]FLORES[/TD]
[/TR]
[TR]
[TD]ÁRBOLES[/TD]
[/TR]
[TR]
[TD]NATURALEZA[/TD]
[/TR]
[TR]
[TD]AIRE FRESCO[/TD]
[/TR]
[TR]
[TD]AIRE LIMPIO[/TD]
[/TR]
[TR]
[TD]NATURALEZA[/TD]
[/TR]
[TR]
[TD]PARQUE[/TD]
[/TR]
[TR]
[TD]JARDINES[/TD]
[/TR]
[TR]
[TD]ESPACIO[/TD]
[/TR]
[TR]
[TD]JARDINES[/TD]
[/TR]
[TR]
[TD]AIRE PURO[/TD]
[/TR]
[TR]
[TD]JARDINES[/TD]
[/TR]
[TR]
[TD]ÁRBOLES[/TD]
[/TR]
[TR]
[TD]PARQUES[/TD]
[/TR]
[TR]
[TD]BOSQUES[/TD]
[/TR]
[TR]
[TD]ÁRBOLES[/TD]
[/TR]
[TR]
[TD]ÁRBOLES[/TD]
[/TR]
[TR]
[TD]ESPACIO[/TD]
[/TR]
[TR]
[TD]ABIERTO[/TD]
[/TR]
[TR]
[TD]VEGETACIÓN[/TD]
[/TR]
[TR]
[TD]SOL[/TD]
[/TR]
[TR]
[TD]JARDINES[/TD]
[/TR]
[TR]
[TD]JARDINES[/TD]
[/TR]
[TR]
[TD]AIRE LIBRE[/TD]
[/TR]
[TR]
[TD]VEGETACIÓN[/TD]
[/TR]
[TR]
[TD]SOMBRA[/TD]
[/TR]
[TR]
[TD]VIENTO[/TD]
[/TR]
[TR]
[TD]JARDINES[/TD]
[/TR]
[TR]
[TD]CAMPOS[/TD]
[/TR]
[TR]
[TD]PARQUES[/TD]
[/TR]
[TR]
[TD]PARQUES[/TD]
[/TR]
[TR]
[TD]JARDINES[/TD]
[/TR]
[TR]
[TD]VERDE[/TD]
[/TR]
[TR]
[TD]SOL[/TD]
[/TR]
[TR]
[TD]VERDE[/TD]
[/TR]
[TR]
[TD]LADERAS[/TD]
[/TR]
[TR]
[TD]BARRANCAS[/TD]
[/TR]
[TR]
[TD]SENDEROS[/TD]
[/TR]
[TR]
[TD]PARQUE[/TD]
[/TR]
[TR]
[TD]AREAS VERDES[/TD]
[/TR]
[TR]
[TD]VERDE[/TD]
[/TR]
[TR]
[TD]AIRE[/TD]
[/TR]
[TR]
[TD]PARQUES[/TD]
[/TR]
[TR]
[TD]PASTO[/TD]
[/TR]
[TR]
[TD]ÁRBOLES[/TD]
[/TR]
[TR]
[TD]ÁRBOLES[/TD]
[/TR]
[TR]
[TD]AREAS VERDES[/TD]
[/TR]
[TR]
[TD]JARDINES[/TD]
[/TR]
[TR]
[TD]PLANTAS[/TD]
[/TR]
[TR]
[TD]VERDE[/TD]
[/TR]
[TR]
[TD]FLORES[/TD]
[/TR]
[TR]
[TD]NATURALEZA[/TD]
[/TR]
[TR]
[TD]SOL[/TD]
[/TR]
[TR]
[TD]VERDE[/TD]
[/TR]
[TR]
[TD]JARDINES[/TD]
[/TR]
[TR]
[TD]PARQUES[/TD]
[/TR]
[TR]
[TD]ÁRBOLES[/TD]
[/TR]
[TR]
[TD]PÁJAROS[/TD]
[/TR]
[TR]
[TD]NATURALEZA[/TD]
[/TR]
[TR]
[TD]JARDINES[/TD]
[/TR]
[TR]
[TD]ÁRBOLES[/TD]
[/TR]
[TR]
[TD]ARENA[/TD]
[/TR]
[TR]
[TD]VERDE[/TD]
[/TR]
[TR]
[TD]ÁRBOLES[/TD]
[/TR]
[TR]
[TD]FRESCO[/TD]
[/TR]
[TR]
[TD]ÁRBOLES[/TD]
[/TR]
[TR]
[TD]AGUA[/TD]
[/TR]
[TR]
[TD]ARDILLAS[/TD]
[/TR]
[TR]
[TD]PATOS[/TD]
[/TR]
[TR]
[TD]PERROS[/TD]
[/TR]
[TR]
[TD]PIEDRAS[/TD]
[/TR]
[TR]
[TD]AIRE LIBRE[/TD]
[/TR]
[TR]
[TD]NATURALEZA[/TD]
[/TR]
[TR]
[TD]AIRE LIBRE[/TD]
[/TR]
[TR]
[TD]AREAS VERDES[/TD]
[/TR]
[TR]
[TD]AIRE FRESCO[/TD]
[/TR]
[TR]
[TD]JARDINES[/TD]
[/TR]
[TR]
[TD]EXTERIOR[/TD]
[/TR]
[TR]
[TD]AMBIENTE[/TD]
[/TR]
[TR]
[TD]NATURALEZA[/TD]
[/TR]
[TR]
[TD]ÁRBOL[/TD]
[/TR]
[TR]
[TD]PÁJAROS[/TD]
[/TR]
[TR]
[TD]VERDE[/TD]
[/TR]
[TR]
[TD]NUBE[/TD]
[/TR]
[TR]
[TD]CIELO[/TD]
[/TR]
[TR]
[TD]PASTO[/TD]
[/TR]
[TR]
[TD]ÁREAS VERDES[/TD]
[/TR]
[TR]
[TD]ÁRBOLES[/TD]
[/TR]
[TR]
[TD]ÁRBOLES[/TD]
[/TR]
[TR]
[TD]VERDE[/TD]
[/TR]
[TR]
[TD]FLORES[/TD]
[/TR]
[TR]
[TD]ÁREAS VERDES[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Most common TEXT [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]most common concept 1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]concept 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]concept 3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]concept 4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]etc... [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Hi
Welcome to the board

Not clear to me. You mean

- most common word
or
- most common cell value

??

For ex.

AIRE
AIRE FRESCO
AIRE
AIRE LIMPIO

- should we consider the word AIRE that appears 4 times
or
- the values of the cells, and in this case

AIRE appears 2 times
AIRE FRESCO appears 1 time
AIRE LIMPIO appears 1 time

please clarify
 
Upvote 0
Add a counting formula and then sort by count descending and text ascending:

[Table="width:, class:grid"][tr][td] [/td][td]
A​
[/td][td]
B​
[/td][td]
C​
[/td][/tr]
[tr][td]
1​
[/td][td]
Text​
[/td][td]
Count​
[/td][td][/td][/tr]

[tr][td]
2​
[/td][td]ÁRBOLES[/td][td]
12​
[/td][td]B2: =COUNTIF($A$2:$A$98, A2)[/td][/tr]

[tr][td]
3​
[/td][td]ÁRBOLES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
4​
[/td][td]ÁRBOLES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
5​
[/td][td]ÁRBOLES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
6​
[/td][td]ÁRBOLES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
7​
[/td][td]ÁRBOLES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
8​
[/td][td]ÁRBOLES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
9​
[/td][td]ÁRBOLES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
10​
[/td][td]ÁRBOLES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
11​
[/td][td]ÁRBOLES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
12​
[/td][td]ÁRBOLES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
13​
[/td][td]ÁRBOLES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
14​
[/td][td]JARDINES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
15​
[/td][td]JARDINES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
16​
[/td][td]JARDINES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
17​
[/td][td]JARDINES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
18​
[/td][td]JARDINES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
19​
[/td][td]JARDINES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
20​
[/td][td]JARDINES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
21​
[/td][td]JARDINES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
22​
[/td][td]JARDINES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
23​
[/td][td]JARDINES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
24​
[/td][td]JARDINES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
25​
[/td][td]JARDINES[/td][td]
12​
[/td][td][/td][/tr]

[tr][td]
26​
[/td][td]VERDE[/td][td]
9​
[/td][td][/td][/tr]

[tr][td]
27​
[/td][td]VERDE[/td][td]
9​
[/td][td][/td][/tr]

[tr][td]
28​
[/td][td]VERDE[/td][td]
9​
[/td][td][/td][/tr]

[tr][td]
29​
[/td][td]VERDE[/td][td]
9​
[/td][td][/td][/tr]

[tr][td]
30​
[/td][td]VERDE[/td][td]
9​
[/td][td][/td][/tr]

[tr][td]
31​
[/td][td]VERDE[/td][td]
9​
[/td][td][/td][/tr]

[tr][td]
32​
[/td][td]VERDE[/td][td]
9​
[/td][td][/td][/tr]

[tr][td]
33​
[/td][td]VERDE[/td][td]
9​
[/td][td][/td][/tr]

[tr][td]
34​
[/td][td]VERDE[/td][td]
9​
[/td][td][/td][/tr]

[tr][td]
35​
[/td][td]NATURALEZA[/td][td]
6​
[/td][td][/td][/tr]

[tr][td]
36​
[/td][td]NATURALEZA[/td][td]
6​
[/td][td][/td][/tr]

[tr][td]
37​
[/td][td]NATURALEZA[/td][td]
6​
[/td][td][/td][/tr]

[tr][td]
38​
[/td][td]NATURALEZA[/td][td]
6​
[/td][td][/td][/tr]

[tr][td]
39​
[/td][td]NATURALEZA[/td][td]
6​
[/td][td][/td][/tr]

[tr][td]
40​
[/td][td]NATURALEZA[/td][td]
6​
[/td][td][/td][/tr]

[tr][td]
41​
[/td][td]PARQUES[/td][td]
5​
[/td][td][/td][/tr]

[tr][td]
42​
[/td][td]PARQUES[/td][td]
5​
[/td][td][/td][/tr]

[tr][td]
43​
[/td][td]PARQUES[/td][td]
5​
[/td][td][/td][/tr]

[tr][td]
44​
[/td][td]PARQUES[/td][td]
5​
[/td][td][/td][/tr]

[tr][td]
45​
[/td][td]PARQUES[/td][td]
5​
[/td][td][/td][/tr]

[tr][td]
46​
[/td][td]AIRE LIBRE[/td][td]
3​
[/td][td][/td][/tr]

[tr][td]
47​
[/td][td]AIRE LIBRE[/td][td]
3​
[/td][td][/td][/tr]

[tr][td]
48​
[/td][td]AIRE LIBRE[/td][td]
3​
[/td][td][/td][/tr]

[tr][td]
49​
[/td][td]AREAS VERDES[/td][td]
3​
[/td][td][/td][/tr]

[tr][td]
50​
[/td][td]AREAS VERDES[/td][td]
3​
[/td][td][/td][/tr]

[tr][td]
51​
[/td][td]AREAS VERDES[/td][td]
3​
[/td][td][/td][/tr]

[tr][td]
52​
[/td][td]FLORES[/td][td]
3​
[/td][td][/td][/tr]

[tr][td]
53​
[/td][td]FLORES[/td][td]
3​
[/td][td][/td][/tr]

[tr][td]
54​
[/td][td]FLORES[/td][td]
3​
[/td][td][/td][/tr]

[tr][td]
55​
[/td][td]SOL[/td][td]
3​
[/td][td][/td][/tr]

[tr][td]
56​
[/td][td]SOL[/td][td]
3​
[/td][td][/td][/tr]

[tr][td]
57​
[/td][td]SOL[/td][td]
3​
[/td][td][/td][/tr]

[tr][td]
58​
[/td][td]AIRE FRESCO[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
59​
[/td][td]AIRE FRESCO[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
60​
[/td][td]ÁREAS VERDES[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
61​
[/td][td]ÁREAS VERDES[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
62​
[/td][td]ESPACIO[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
63​
[/td][td]ESPACIO[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
64​
[/td][td]FRESCO[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
65​
[/td][td]FRESCO[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
66​
[/td][td]PÁJAROS[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
67​
[/td][td]PÁJAROS[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
68​
[/td][td]PARQUE[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
69​
[/td][td]PARQUE[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
70​
[/td][td]PASTO[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
71​
[/td][td]PASTO[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
72​
[/td][td]SOMBRA[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
73​
[/td][td]SOMBRA[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
74​
[/td][td]VEGETACIÓN[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
75​
[/td][td]VEGETACIÓN[/td][td]
2​
[/td][td][/td][/tr]

[tr][td]
76​
[/td][td]ABIERTO[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
77​
[/td][td]AGUA[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
78​
[/td][td]AIRE[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
79​
[/td][td]AIRE LIMPIO[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
80​
[/td][td]AIRE PURO[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
81​
[/td][td]AMBIENTE[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
82​
[/td][td]ÁRBOL[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
83​
[/td][td]ARDILLAS[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
84​
[/td][td]ARENA[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
85​
[/td][td]BARRANCAS[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
86​
[/td][td]BOSQUES[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
87​
[/td][td]CAMPOS[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
88​
[/td][td]CIELO[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
89​
[/td][td]EXTERIOR[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
90​
[/td][td]LADERAS[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
91​
[/td][td]Naturaleza asociada[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
92​
[/td][td]NUBE[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
93​
[/td][td]PATOS[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
94​
[/td][td]PERROS[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
95​
[/td][td]PIEDRAS[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
96​
[/td][td]PLANTAS[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
97​
[/td][td]SENDEROS[/td][td]
1​
[/td][td][/td][/tr]

[tr][td]
98​
[/td][td]VIENTO[/td][td]
1​
[/td][td][/td][/tr]
[/table]
 
Upvote 0
If you want to see the list without repeats, copy the formula column, paste as values, then select both columns and do Data > Remove Duplicates:

[Table="width:, class:grid"][tr][td] [/td][td]
A​
[/td][td]
B​
[/td][/tr]
[tr][td]
1​
[/td][td]
Text​
[/td][td]
Count​
[/td][/tr]

[tr][td]
2​
[/td][td]ÁRBOLES[/td][td]
12​
[/td][/tr]

[tr][td]
3​
[/td][td]JARDINES[/td][td]
12​
[/td][/tr]

[tr][td]
4​
[/td][td]VERDE[/td][td]
9​
[/td][/tr]

[tr][td]
5​
[/td][td]NATURALEZA[/td][td]
6​
[/td][/tr]

[tr][td]
6​
[/td][td]PARQUES[/td][td]
5​
[/td][/tr]

[tr][td]
7​
[/td][td]AIRE LIBRE[/td][td]
3​
[/td][/tr]

[tr][td]
8​
[/td][td]AREAS VERDES[/td][td]
3​
[/td][/tr]

[tr][td]
9​
[/td][td]FLORES[/td][td]
3​
[/td][/tr]

[tr][td]
10​
[/td][td]SOL[/td][td]
3​
[/td][/tr]

[tr][td]
11​
[/td][td]AIRE FRESCO[/td][td]
2​
[/td][/tr]

[tr][td]
12​
[/td][td]ÁREAS VERDES[/td][td]
2​
[/td][/tr]

[tr][td]
13​
[/td][td]ESPACIO[/td][td]
2​
[/td][/tr]

[tr][td]
14​
[/td][td]FRESCO[/td][td]
2​
[/td][/tr]

[tr][td]
15​
[/td][td]PÁJAROS[/td][td]
2​
[/td][/tr]

[tr][td]
16​
[/td][td]PARQUE[/td][td]
2​
[/td][/tr]

[tr][td]
17​
[/td][td]PASTO[/td][td]
2​
[/td][/tr]

[tr][td]
18​
[/td][td]SOMBRA[/td][td]
2​
[/td][/tr]

[tr][td]
19​
[/td][td]VEGETACIÓN[/td][td]
2​
[/td][/tr]

[tr][td]
20​
[/td][td]ABIERTO[/td][td]
1​
[/td][/tr]

[tr][td]
21​
[/td][td]AGUA[/td][td]
1​
[/td][/tr]

[tr][td]
22​
[/td][td]AIRE[/td][td]
1​
[/td][/tr]

[tr][td]
23​
[/td][td]AIRE LIMPIO[/td][td]
1​
[/td][/tr]

[tr][td]
24​
[/td][td]AIRE PURO[/td][td]
1​
[/td][/tr]

[tr][td]
25​
[/td][td]AMBIENTE[/td][td]
1​
[/td][/tr]

[tr][td]
26​
[/td][td]ÁRBOL[/td][td]
1​
[/td][/tr]

[tr][td]
27​
[/td][td]ARDILLAS[/td][td]
1​
[/td][/tr]

[tr][td]
28​
[/td][td]ARENA[/td][td]
1​
[/td][/tr]

[tr][td]
29​
[/td][td]BARRANCAS[/td][td]
1​
[/td][/tr]

[tr][td]
30​
[/td][td]BOSQUES[/td][td]
1​
[/td][/tr]

[tr][td]
31​
[/td][td]CAMPOS[/td][td]
1​
[/td][/tr]

[tr][td]
32​
[/td][td]CIELO[/td][td]
1​
[/td][/tr]

[tr][td]
33​
[/td][td]EXTERIOR[/td][td]
1​
[/td][/tr]

[tr][td]
34​
[/td][td]LADERAS[/td][td]
1​
[/td][/tr]

[tr][td]
35​
[/td][td]Naturaleza asociada[/td][td]
1​
[/td][/tr]

[tr][td]
36​
[/td][td]NUBE[/td][td]
1​
[/td][/tr]

[tr][td]
37​
[/td][td]PATOS[/td][td]
1​
[/td][/tr]

[tr][td]
38​
[/td][td]PERROS[/td][td]
1​
[/td][/tr]

[tr][td]
39​
[/td][td]PIEDRAS[/td][td]
1​
[/td][/tr]

[tr][td]
40​
[/td][td]PLANTAS[/td][td]
1​
[/td][/tr]

[tr][td]
41​
[/td][td]SENDEROS[/td][td]
1​
[/td][/tr]

[tr][td]
42​
[/td][td]VIENTO[/td][td]
1​
[/td][/tr]
[/table]
 
Upvote 0
Hi
Welcome to the board

Not clear to me. You mean

- most common word
or
- most common cell value

??

For ex.

AIRE
AIRE FRESCO
AIRE
AIRE LIMPIO

- should we consider the word AIRE that appears 4 times
or
- the values of the cells, and in this case

AIRE appears 2 times
AIRE FRESCO appears 1 time
AIRE LIMPIO appears 1 time

please clarify

MOST COMMON WORDS ONLY, but the solution of count words it's simplest and elegant. But I wish to have a formula to show most common words with TEXT not numbers.

Thank's a lot.
 
Upvote 0
You could use text to columns to split the phrases, stack one below the other, and then proceed as previously described.

[Table="width:, class:grid"][tr][td] [/td][td]
A​
[/td][td]
B​
[/td][/tr]
[tr][td]
1​
[/td][td]
Word​
[/td][td]
Count​
[/td][/tr]

[tr][td]
2​
[/td][td]ÁRBOLES[/td][td]
13​
[/td][/tr]

[tr][td]
3​
[/td][td]JARDINES[/td][td]
12​
[/td][/tr]

[tr][td]
4​
[/td][td]VERDE[/td][td]
9​
[/td][/tr]

[tr][td]
5​
[/td][td]AIRE[/td][td]
8​
[/td][/tr]

[tr][td]
6​
[/td][td]Naturaleza[/td][td]
7​
[/td][/tr]

[tr][td]
7​
[/td][td]PARQUES[/td][td]
5​
[/td][/tr]

[tr][td]
8​
[/td][td]VERDES[/td][td]
5​
[/td][/tr]

[tr][td]
9​
[/td][td]FRESCO[/td][td]
4​
[/td][/tr]

[tr][td]
10​
[/td][td]AREAS[/td][td]
3​
[/td][/tr]

[tr][td]
11​
[/td][td]FLORES[/td][td]
3​
[/td][/tr]

[tr][td]
12​
[/td][td]LIBRE[/td][td]
3​
[/td][/tr]

[tr][td]
13​
[/td][td]SOL[/td][td]
3​
[/td][/tr]

[tr][td]
14​
[/td][td]ÁREAS[/td][td]
2​
[/td][/tr]

[tr][td]
15​
[/td][td]ESPACIO[/td][td]
2​
[/td][/tr]

[tr][td]
16​
[/td][td]PÁJAROS[/td][td]
2​
[/td][/tr]

[tr][td]
17​
[/td][td]PARQUE[/td][td]
2​
[/td][/tr]

[tr][td]
18​
[/td][td]PASTO[/td][td]
2​
[/td][/tr]

[tr][td]
19​
[/td][td]SOMBRA[/td][td]
2​
[/td][/tr]

[tr][td]
20​
[/td][td]VEGETACIÓN[/td][td]
2​
[/td][/tr]

[tr][td]
21​
[/td][td]ABIERTO[/td][td]
1​
[/td][/tr]

[tr][td]
22​
[/td][td]AGUA[/td][td]
1​
[/td][/tr]

[tr][td]
23​
[/td][td]AMBIENTE[/td][td]
1​
[/td][/tr]

[tr][td]
24​
[/td][td]ÁRBOL[/td][td]
1​
[/td][/tr]

[tr][td]
25​
[/td][td]ARDILLAS[/td][td]
1​
[/td][/tr]

[tr][td]
26​
[/td][td]ARENA[/td][td]
1​
[/td][/tr]

[tr][td]
27​
[/td][td]asociada[/td][td]
1​
[/td][/tr]

[tr][td]
28​
[/td][td]BARRANCAS[/td][td]
1​
[/td][/tr]

[tr][td]
29​
[/td][td]BOSQUES[/td][td]
1​
[/td][/tr]

[tr][td]
30​
[/td][td]CAMPOS[/td][td]
1​
[/td][/tr]

[tr][td]
31​
[/td][td]CIELO[/td][td]
1​
[/td][/tr]

[tr][td]
32​
[/td][td]EXTERIOR[/td][td]
1​
[/td][/tr]

[tr][td]
33​
[/td][td]FRONDOSOS[/td][td]
1​
[/td][/tr]

[tr][td]
34​
[/td][td]LADERAS[/td][td]
1​
[/td][/tr]

[tr][td]
35​
[/td][td]LIMPIO[/td][td]
1​
[/td][/tr]

[tr][td]
36​
[/td][td]NUBE[/td][td]
1​
[/td][/tr]

[tr][td]
37​
[/td][td]PATOS[/td][td]
1​
[/td][/tr]

[tr][td]
38​
[/td][td]PERROS[/td][td]
1​
[/td][/tr]

[tr][td]
39​
[/td][td]PIEDRAS[/td][td]
1​
[/td][/tr]

[tr][td]
40​
[/td][td]PLANTAS[/td][td]
1​
[/td][/tr]

[tr][td]
41​
[/td][td]PURO[/td][td]
1​
[/td][/tr]

[tr][td]
42​
[/td][td]SENDEROS[/td][td]
1​
[/td][/tr]

[tr][td]
43​
[/td][td]VIENTO[/td][td]
1​
[/td][/tr]
[/table]
 
Upvote 0

Forum statistics

Threads
1,223,108
Messages
6,170,142
Members
452,304
Latest member
Thelingly95

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top