[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [the cryptic @@#$7]
From: |
Uwe Brauer |
Subject: |
Re: [the cryptic @@#$7] |
Date: |
Sun, 08 Oct 2023 19:46:25 +0200 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/29.0.50 (gnu/linux) |
> Uwe Brauer <oub@mat.ucm.es> writes:
> The ref "remote(table1,@2$7..@>$7)" targets a range, containing all fields
of
> colum 7. So, for each field, you get the same value: an array
> containing all the field values: [22, 19, 19].
> See (info "(org) References"), in the section:
> "Field coordinates in formulas"
> "‘@#’ is substituted with the row number of the field where the
> current result will go to".
Aha, and has the benefit that the lookup call is not needed, but is more
cryptic thanks for clarifying this.
--
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.
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/
smime.p7s
Description: S/MIME cryptographic signature
- equivalent of VLOOKUP (in ods) to org-table, Uwe Brauer, 2023/10/08
- Re: equivalent of VLOOKUP (in ods) to org-table, Bruno Barbier, 2023/10/08
- Re: equivalent of VLOOKUP (in ods) to org-table, Uwe Brauer, 2023/10/08
- [the cryptic @@#$7] (was: equivalent of VLOOKUP (in ods) to org-table), Uwe Brauer, 2023/10/08
- Re: [the cryptic @@#$7] (was: equivalent of VLOOKUP (in ods) to org-table), Bruno Barbier, 2023/10/08
- Re: [the cryptic @@#$7],
Uwe Brauer <=
- Re: [the cryptic @@#$7], Uwe Brauer, 2023/10/11
- Re: [the cryptic @@#$7], Bruno Barbier, 2023/10/12
- Re: [the cryptic @@#$7], Uwe Brauer, 2023/10/12
- Re: equivalent of VLOOKUP (in ods) to org-table, Bruno Barbier, 2023/10/08
- Re: equivalent of VLOOKUP (in ods) to org-table, Uwe Brauer, 2023/10/08