Haz tu Pregunta

perfil de kdev - actividad

2021-03-18 00:34:23 +0200 recibió una medalla  Pregunta Famosa (fuente)
2021-03-18 00:34:23 +0200 recibió una medalla  Pregunta Notable (fuente)
2021-01-01 23:25:38 +0200 recibió una medalla  Pregunta Famosa (fuente)
2021-01-01 23:25:38 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-12-08 09:31:38 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-12-06 21:12:16 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-12-04 21:23:05 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-12-04 09:06:23 +0200 realizó una pregunta Query like SQL on office calc

Query like SQL on office calc Hi :), Is it possible to query tables of a spreadsheet using SQL? I saw a similar questi

2020-11-08 12:07:00 +0200 comentar respuesta How can I get the cells that repeat in lists from multiple sheets?

Hi, Thank you so much, this works. Best regards

2020-11-08 12:07:00 +0200 recibió una medalla  Comentador
2020-11-08 12:06:21 +0200 la mejor respuesta fue marcada How can I get the cells that repeat in lists from multiple sheets?

Example:

Sheet A

Col A Val1 Val2 Val3

Sheet B

Col A Val1 Val2 Val4

Sheet C

Col A Val1 Val7

I want to get in other sheet, all the values from Col A, from each sheet, that have occurrence > 1 (repeated) and it's count. In this example would be:

image description

How can I achieve this?

Thanks in advance.

2020-11-08 11:51:52 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-10-25 18:17:31 +0200 recibió una medalla  Pregunta Famosa (fuente)
2020-10-17 22:39:02 +0200 realizó una pregunta How can I get the cells that repeat in lists from multiple sheets?

How can I get the cels that repeat in lists from multiple sheets? Example: Sheet A Col A Val1 Val2 Val3 Sheet B Col

2020-10-13 10:52:41 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-08-25 04:08:37 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-08-24 17:30:16 +0200 comentar respuesta How to filter column with advanced filter that matches any string that has a given text?

If your want to find whole words only use That doesn't work as expected. I tested with "xhashtag2x" and still retur

2020-08-24 17:29:40 +0200 comentar respuesta How to filter column with advanced filter that matches any string that has a given text?

If your want to find whole words only use That doesn't work as expected. I tested with "xhashtag2x" and still retur

2020-08-23 21:16:17 +0200 la mejor respuesta fue marcada How to filter column with advanced filter that matches any string that has a given text?

An example:

Table

I use column ColB to store multiple hashtags. How can I filter the table by ColB with a string to match any string that any cell under ColB has, no matter it's position?

Example: I want to filter ColB by hashtag2 to give me all rows that have that string, no matter it's position inside the cell content.

Note: I believe that this can be done with regex but idk how...

2020-08-23 21:16:14 +0200 comentar respuesta How to filter column with advanced filter that matches any string that has a given text?

Hello, Many thanks, this works like a charm! Regards

2020-08-23 21:12:08 +0200 recibió una medalla  Entusiasta
2020-08-22 16:58:38 +0200 recibió una medalla  Editor (fuente)
2020-08-22 16:57:53 +0200 realizó una pregunta How to filter column with advanced filter that matches any string that has a given text?

How to filter column with advanced filter that matches any string that has a given text? An example: I use column Col

2020-06-07 22:11:55 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-06-07 17:11:35 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-06-07 12:47:43 +0200 realizó una pregunta How can i get the sum of values for each category?

How can i get the sum of values for each category? I have this table to register my expenses: I want other table wher

2020-05-28 23:04:30 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-05-27 23:53:17 +0200 comentar respuesta How to create predefined table filters?

Yes, still doesn't remove the filter :/

2020-05-27 23:35:15 +0200 comentar respuesta How to create predefined table filters?

Function Reset Filter doesn't work for advanced filters. Currently i can only remove them doing ctrl+z. Is there other w

2020-05-27 13:41:50 +0200 la mejor respuesta fue marcada How to create predefined table filters?

Example:

image description

This table has autofilter enabled in the headings (| ColA | ColB | ColC |).

I want to create predefined so that instead of manually select each option in the dropdown, I can just "click" or do something quicker. Example of custom filters:

ColA=1, ColB=2, ColC=3

ColA=2, ColB=1, ColC=2 ...

Is there some built-in functionality or any hack that does this?

2020-05-27 13:41:48 +0200 comentar respuesta How to create predefined table filters?

Ok, now I was able to reproduce your example (this video also helps). Do you know an easy/fast way to activate and deact

2020-05-27 13:09:03 +0200 comentar respuesta How to create predefined table filters?

That indeed works in your file but i've been trying to understand the logic to reproduce it but i'm not getting it. How

2020-05-27 12:49:40 +0200 la mejor respuesta fue marcada How to apply alternate row background colors? And how to apply this in tables that already have conditional formatting?

How can I get alternate row background colors like this:

image description

(Note the alternate row background on the 1st table and the alternate col background on the 2st table)

I also have some tables with conditional formatting (ex: for colA, if AnyCell="a" apply StyleX. "StyleX" change both Cell font and background). Can I add alternate row background colors to them too? Preferably an easy way to do this...

2020-05-27 12:37:44 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-05-23 12:37:38 +0200 realizó una pregunta How to apply alternate row background colors? And how to apply this in tables that already have conditional formatting?

How to apply alternate row background colors? And how to apply this in tables that already have conditional formatting?

2020-05-23 11:45:40 +0200 realizó una pregunta How to create predefined table filters?

How to create predefined table filters? Example: This table has autofilter enabled in the headings (| ColA | ColB | C