We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Moshpirit's profile - activity

2021-05-27 14:40:33 +0200 marked best answer ¿Cómo extraer los valores asociados a unas celdas cuyos nombres coinciden?

Suponemos una lista A de nombres y una columna B de valores asociados a esos nombres. ¿Cómo puedo obtener los valores cuyo nombre contengan, por ejemplo, "Nombre1"? Ejemplifico a continuación:

Nombre1 | 23
Nombre3 | 45
Nombre1 | 28
Nombre4 | 2
Nombre2 | 7
Nombre1 | 4

Lo que quiero es una función que me muestre en una tabla únicamente los valores correspondientes a "Nombre1" ignorando los que no sin dejar filas en blanco:

23
28
4

He pensado en BDEXTRAER() (ver wiki) pero creo que solo aplica para el valor de una celda, no para varias.

2021-05-27 11:32:52 +0200 commented question ¿Cómo extraer los valores asociados a unas celdas cuyos nombres coinciden?

Muchas gracias por comentar, @LeroyG, creo que las tablas dinámicas (que acabo de descubrir gracias a ti y me han gusta

2021-05-27 03:17:21 +0200 asked a question Any way to extract associated values of cells that have the same name?

Any way to extract associated values of cells that have the same name? If I have a column A of names and another B with

2021-05-26 18:41:44 +0200 asked a question ¿Cómo extraer los valores asociados a unas celdas cuyos nombres coinciden?

¿Cómo extraer los valores asociados a unas celdas cuyos nombres coinciden? Suponemos una lista A de nombres y una column

2021-05-25 15:34:59 +0200 received badge  Famous Question (source)
2021-05-25 15:34:59 +0200 received badge  Notable Question (source)
2021-05-25 15:26:38 +0200 received badge  Notable Question (source)
2021-02-11 02:03:26 +0200 asked a question Any way to get the Descriptive Statistics resume (through Data) when using absolute frequencies?

Any way to get the Descriptive Statistics resume (through Data) when using absolute frequencies? To run the descriptive

2021-01-23 05:35:20 +0200 received badge  Famous Question (source)
2020-12-20 23:25:02 +0200 marked best answer How to move the position of a comment in LO Writer?

Imagine this text, where "*" means there's a comment:

Fractal and multifractal analysis are commonly used to evaluate pore structure and its heterogeneity. Compared with fractal analysis, multifractal analysis can determine the globe and local properties of pores in rocks.* Low-field NMR measurement in laboratory and field wells is an important method for studying pore structures and other petrophysical parameters of reservoirs.

So in this example there is a comment after "pores in rocks.", but let's imagine I want to move it after "Low-field NMR":

Fractal and multifractal analysis are commonly used to evaluate pore structure and its heterogeneity. Compared with fractal analysis, multifractal analysis can determine the globe and local properties of pores in rocks. Low-field NMR* measurement in laboratory and field wells is an important method for studying pore structures and other petrophysical parameters of reservoirs.

Is there any way to just move the comment without copying/pasting it in a new comment?

2020-12-20 18:12:59 +0200 received badge  Popular Question (source)
2020-12-19 19:57:08 +0200 commented answer How to move the position of a comment in LO Writer?

Cool! thanks! IDK why but I thought I could not do that.

2020-12-19 19:36:55 +0200 received badge  Famous Question (source)
2020-12-19 19:36:06 +0200 asked a question How to move the position of a comment in LO Writer?

How to move the position of a comment in LO Writer? Imagine this text, where "*" means there's a comment: Fractal an

2020-11-06 17:26:26 +0200 commented answer [Writer] Why while the style is the same (Text body), they appear so differently?

I see, thanks!

2020-11-06 10:45:24 +0200 received badge  Popular Question (source)
2020-11-06 00:38:46 +0200 received badge  Enthusiast
2020-11-05 23:33:59 +0200 commented answer [Writer] Why while the style is the same (Text body), they appear so differently?

I see, thank you so much for such complete explanation! I was asking before noticing your new comment if there is a way

2020-11-05 22:35:35 +0200 commented answer [Writer] Why while the style is the same (Text body), they appear so differently?

I see, thank you so much!! That was perfectly explained. I imagine there is no way to do that without removing the bold

2020-11-05 22:35:35 +0200 received badge  Commentator
2020-11-05 22:32:14 +0200 marked best answer [Writer] Why while the style is the same (Text body), they appear so differently?

I'm giving some style to some debating notes that a friend shared with me but sometimes I find this: when I select the text and the format into Text body ("Cuerpo de texto" in Spanish), it's just partially modified. Some of the text keeps its previous format: Corbel font (12 pts) instead of Liberation Sans (11pts).

I'll leave some screenshots below and a demo ODT file attached.
I'm using LO 7.0.3.1 on GNU/Linux.


Styling ODT file demo.odt

screenshot 1: Properties

screenshot 2: Styles and formats

2020-11-05 21:41:20 +0200 asked a question [Writer] Why while the style is the same (Text body), they appear so differently?

[Writer] Why while the style is the same (Text body), they appear so differently? I'm giving some style to some debating

2020-10-20 16:55:03 +0200 commented answer IDK why FIND() gives me this value when comparing these two tables on LO Calc

Because I had no idea that such tool existed. I should search for some cheatsheet for LO Calc and keep it around when I'

2020-10-20 15:21:05 +0200 commented answer IDK why FIND() gives me this value when comparing these two tables on LO Calc

That was it!! thanks a lot! I think LO should have (if it doesn't) some tool to remove latest spaces.

2020-10-20 15:19:14 +0200 marked best answer IDK why FIND() gives me this value when comparing these two tables on LO Calc

I have two tables:

  • columns A (names) and B (empty)
  • columns C (names) and D (values)

Columns A and B are sorted in a sheet in a way, C and D are sorted differently in another sheet. I want to get the values of column D in B respecting the way is sorted in the first sheet. In order to make it simple here, we'll say they all are in the same sheet but with a different sorting method.

Here's an little example where I removed most of the cells:

| Column A   | Column B | Column C  | Column D |
|------------|----------|-----------|----------|
| SI06SE020  |          | SI06JA038 | 98,66    |
| SI06JA023  |          | MI06JA109 | 96,8     |
| SI06JA038  |          | SI06JA033 | 94,98    |
| SI06JA039  |          | SI06JA107 | 94,91    |
| SI06JA040  |          | SI06JA124 | 94,81    |
| SI06JA124  |          | SI06JA039 | 91,18    |
| SI06SE139  |          | SI06SE140 | 91,28    |
| MI06HU065  |          | SI06SE020 | 86,82    |

As you can see, A2 (SI06SE020) is the same value as the latest of column C.

I'm trying to get D values comparing A with C with Find(), so B2 formula would be =FIND(A2;$C$2:$C$57;$D$2:$D$57). Instead of getting 86,82, I'm getting 94,81 (which belongs to SI06JA039) but have no idea of why.

2020-10-20 15:17:28 +0200 received badge  Popular Question (source)
2020-10-20 14:56:37 +0200 commented question Is there a LibreOffice .odt, .ods viewer for Android?

Definitely Collabora Office for Android. Also AndrOpen Office

2020-10-20 13:39:58 +0200 commented answer IDK why FIND() gives me this value when comparing these two tables on LO Calc

Thanks! I tried VLOOKUP before but I got #N/A instead of the result. Even though there's 0 in the last variable of =VLOO

2020-10-20 12:40:37 +0200 asked a question IDK why FIND() gives me this value when comparing these two tables on LO Calc

IDK why FIND() gives me this value when comparing these two tables on LO Calc I have two tables: columns A (names) an

2020-10-20 11:56:17 +0200 received badge  Famous Question (source)
2020-10-20 11:56:17 +0200 received badge  Notable Question (source)
2020-10-20 11:56:17 +0200 received badge  Popular Question (source)
2020-08-10 18:37:22 +0200 received badge  Notable Question (source)
2020-08-09 20:08:37 +0200 received badge  Popular Question (source)
2020-08-09 19:54:26 +0200 marked best answer if cell contains this text then [closed]

I saw this post but in my case I want to use it with "IF()" (or anything that may give me the result I'm looking for):

Column A has some text | Column B has numbers | for column C, if a cell of column A contains "TJ" within the cell, then write the number this cell has next to it.

Eg:

A | B | C   
--|--|--   
ABC | 5 |    
TJK | 6 | 6   
NGB | 0 |    
CTJ-2 | 18 | 18

EDIT:

What would be the easier way to include another text condition?

=IF(OR(ISNUMBER(FIND("TJ";A1));ISNUMBER(FIND("BLA";A1)));B1;"") maybe?

2020-08-09 19:54:26 +0200 commented answer if cell contains this text then [closed]

Thank you so much! That was a very complete an helpful answer!! :)