Jan 14 2019 07:23 PM
Hi i have below information where have information that i do not need, for sample lines from 1 to 4 and what i need is only description in line 5 (the logic is for each empty cell i am going to need the above description, and put in another cell, so it is the same rule for all file ) i wonder if you can help me with some formula
Lines | sddd | COL1 | Description | |
1 | 1 | 1 | Servicios de importacion en USD | |
2 | 1 | 2 | Servicios de importacion en USD - Se | |
3 | 1 | 3 | Servicios de importacion en USD - Servic | |
4 | 1 | 4 | Servicios de importacion en USD - Servicios | |
5 | 1 | 5 | Servicios de importacion en USD - Servicios de impo | |
6 | 1 | |||
7 | 1 | 1 | Servicio especializado de soporte tecnic | |
8 | 1 | 2 | Servicio especializado de soporte tecnico par |
Jan 14 2019 08:30 PM
Jan 14 2019 08:36 PM
or this one (which references blanks on the next row)
Jan 14 2019 09:05 PM - edited Jan 14 2019 09:07 PM
@Wyn Hopkins wrote:or this one (which references blanks on the next row)
Thank you very much,
I attached a sample, Bold line is the one requiered, so i need to separe this line from the rest of the text (So later i can sort and get only thie required data)
1 | COL1 | Description |
2 | 1 | Servicios |
3 | 2 | Servicios de |
4 | 3 | Servicios de i |
5 | 4 | Servicios de im |
6 | 5 | Servicios de importacion |
7 | ||
8 | 1 | Servicio especializado |
9 | 2 | Servicio especializado de |
10 | 3 | Servicio especializado de s |
11 | 4 | Servicio especializado de so |
12 | 5 | Servicio especializado de sopo |
13 | 6 | Servicio especializado de soport |
14 | 7 | Servicio especializado de soporte |
15 | 8 | Servicio especializado de soporte t |
16 | 9 | Servicio especializado de soporte te |
17 | 10 | Servicio especializado de soporte tec |
18 | 11 | Servicio especializado de soporte tecni |
19 | 12 | Servicio especializado de soporte tecnic |
20 | 13 | Servicio especializado de soporte tecnico |
21 | 14 | Servicio especializado de soporte tecnico p |
22 | 15 | Servicio especializado de soporte tecnico pa |
23 | 16 | Servicio especializado de soporte tecnico par |
24 | 17 | Servicio especializado de soporte tecnico para |
25 | ||
26 | 1 | Tarjetas |
27 | 2 | Tarjetas d |
28 | 3 | Tarjetas de |
29 | 4 | Tarjetas de p |
30 | 5 | Tarjetas de pre |
31 | 6 | Tarjetas de pres |
32 | 7 | Tarjetas de prese |
33 | 8 | Tarjetas de presen |
34 | 9 | Tarjetas de presenta |
35 | 10 | Tarjetas de presentac |
36 | 11 | Tarjetas de presentaci |
37 | 12 | Tarjetas de presentacion |
38 | ||
39 | Etc | |
40 |
Jan 14 2019 09:19 PM
Thank you, but in second group did not work
COL1 | Formula | |
1 | Servicios de importacion en USD - Servic | |
2 | Servicios d | |
3 | Servicios de importacion | |
4 | Servicios de importacion e | |
5 | Servicios de importacion | Servicios de importacion |
1 | Servicio especializado de soporte tecnic | |
2 | Servicio especializado de soporte tecnico | |
3 | Servicio especializado de soporte tecnico | |
4 | Servicio especializado de soporte tecnico | |
5 | Servicio especializado de soporte tecnico | |
6 | Servicio especializado de soporte tecnico | |
7 | Servicio especializado de soporte tecnico | |
8 | Servicio especializado de soporte tecnico | |
9 | Servicio especializado de soporte tecnico | |
10 | Servicio especializado de soporte tecnico | |
11 | Servicio especializado de soporte tecnico | |
12 | Servicio especializado de soporte tecnico | |
13 | Servicio especializado de soporte tecnico | |
14 | Servicio especializado de soporte tecnico | |
15 | Servicio especializado de soporte tecnico | |
16 | Servicio especializado de soporte tecnico | |
17 | Servicio especializado de soporte tecnico | DOES NOT WORK HERE |
Jan 14 2019 09:22 PM
Jan 15 2019 06:25 AM - edited Jan 15 2019 04:10 PM
Hello Wyn
Sure i did, i have attached the file with formula, it seems to be near of the solution, i think this formula require some adjusments or i am doing something wrong. Because it worked in the first group of data, but in the second not (It was un blank as well). Do you know why in the Second group of date it did not work ?
Jan 15 2019 04:40 PM
Hi @yobas
The cell wasn't actually blank, there was a space there
So I've updated the formula to handle spaces too
Jan 16 2019 10:52 AM
Hi Wyn
Excellent, thank you very much, it seems to worked, however, when i copy formula and paste as value, and i try to sort (To delete blank espaces) it change the description to "#¿NOMBRE?" in another cells, even in description field as well, do you know how can. i fix this
Jan 16 2019 01:02 PM - edited Jan 16 2019 01:02 PM
I note that the cells empty are not empty, putting a filter i see values like #¡REF¡ and #¿NOMBRE?, how can i do that the "empty cells" will be really empty
Jan 17 2019 10:25 AM
Thank you
In second tab, is information without sort, the third is sorted, in column E i need to deleted blank spaces and leave only the ones with text