2023 Archives by date, by thread · List index

# Re: [libreoffice-users] split a huge table in subtables (say on different sheets) and link some columns between these tables???

```Hi,

You can use the SUMIF function to have the ResSh1 and ResSh2 of final
to be updated each time you make an entry. If you only have one "Smith"
per table, you can use VLOOKUP to fetch the \$7 value for Smith. You
will use these functions to find the "Smith" values in each of your
smaller tables.

Assuming "Name" of table1 is in A1, "Smith" of final is in A2, and
there are 20 rows in table1, using SUMIF for the ResSh1 in final would
bring:

=SUMIF(table1.\$a\$1:\$a:20,CONCATENATE("=",final.a2),table1.\$g\$1:\$g\$20)

For ResSh2, you will replace table1 with table2.

If you want to use VLOOKUP, then you will have, for final.ResSh1:

=VLOOKUP(final.a2,table1.\$a\$1:\$g\$20,7,FALSE())

I hope this helps.
Rémy.

Le mardi 03 octobre 2023 à 18:44 +0200, Uwe Brauer a écrit :
```
```Hi

I am facing the following problem, I work with a table with 6 rows
but
56 columns. Of course I can hide some columns but I find this not
very
comfortable.
So the question is can I split this table say in 8 tales, each with 7
columns.

In each table the last column gives me a result of certain operation,
say

#+begin_src
#+Name: table1
```
```Name  | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh1 |
-------+-----+-----+-----+-----+-----+--------|
Smith |   2 |   3 |   4 |   6 |   7 | 22     |
```
```#+TBLFM: \$7=vsum(\$2..\$6);f2

#+Name: table2
```
```Name  | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh2  |
-------+-----+-----+-----+-----+-----+--------|
Smith |   1 |   3 |   5 |   8 |   9 |     26 |
```
```#+TBLFM: \$7=vsum(\$2..\$6);f2

#+Name: final
```
```Name  | ResSh1 | ResSh2 | Total |
-------+--------+--------+-------|
smith |     22 |     26 | 48    |
```
```#+TBLFM: \$4=vsum(\$2..\$3);f2

#+end_src

So that every time I actualise any column in any table, that
table gets updated and the final one

Is this possible. It is possible in emacs org mode with its table
spreadsheet, however my colleagues use either LO or Excel, so it
would
be great if this were possible.

BTW is html mail possible/allowd on this lis?t (that would simplify
the
display of my tables)

Thanks and regards

Uwe Brauer

--
Warning: Content may be disturbing to some audiences
I strongly condemn Putin's war of aggression against Ukraine.
I support to deliver weapons to Ukraine's military.
I support the NATO membership of Ukraine.
I support the EU membership of Ukraine.

```
```

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/