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

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

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:

How can I achieve this?

Thanks in advance.

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

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

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

An example:

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...

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

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

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

Yes, still doesn't remove the filter :/

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

Example:

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?

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

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

How can I get alternate row background colors like this:

(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...

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

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