Differences

This shows you the differences between two versions of the page.

--- en:concepts:djeeniformula [2020/12/13 15:45]
tiger [Relative folder specification]
+++ en:concepts:djeeniformula [2023/07/26 14:41] (current)
tiger [Last row in a column]
@@ Line 1: / Line 1: @@
+{{indexmenu_n>2}}
 ====== Djeeni Formula ======
@@ Line 11: / Line 12: @@
 ===== Djeeni formula extensions overview =====
-To enable the Djeeni extensions within MS Excel formulas Djeeni uses the [.....] syntax. That means you have to enclose most of the Djeeni formulas in the square brackets. See the sections below the overview table for detailed explanations.
+To enable the Djeeni extensions within MS Excel formulas Djeeni uses the [.....] syntax. That means you have to enclose most of the Djeeni formulas in square brackets. See the sections below the overview table for detailed explanations.
 ^ Djeeni formula extensions overview ||||
@@ Line 19: / Line 20: @@
 | Cell Value   | [=...] | value of the cell D4 | [=wsName!D4] |
 | Named range | [:...] | namedRange | [:namedRange] |
-| Cell reference of a located value | [# ... %%|%%cell]| - | [#ceValue%%|%%cell] |
+| Cell reference of a found cell | [# ... %%|%%cell]| - | [#ceCell%%|%%cell] |
-| Row number of a located value | [# ... %%|%%row]| - | [#ceValue%%|%%row] |
+| Row number of a found cell | [# ... %%|%%row]| - | [#ceCell%%|%%row] |
-| Column letter of a located value | [# ... %%|%%column]| - | [#ceValue%%|%%column] |
+| Column letter of a found cell | [# ... %%|%%column]| - | [#ceCell%%|%%column] |
-| Last column with data (in the first row) | [#ColumnEnd] or #ColumnEnd | - | [$wsName!**[#ColumnEnd]**2] |
+| Last column with data in row 1 | [#ColumnEnd] or #ColumnEnd | - | [$wsName!**[#ColumnEnd]**2] |
 | Last column with data in a specific row | [#ColumnEnd%%|%%Row] | - | [$wsName!**[#ColumnEnd%%|%%2]**2] |
-| Last row with data (in column A) | [#RowEnd] or #RowEnd | - | [$wsName!C**#RowEnd**] |
+| First column after last with data in row 1 | [#ColumnNext] or #ColumnNext | - | [$wsName!**[#ColumnNext]**2] |
+| First column after last one with data in a specific row | [#ColumnNext%%|%%Row] | - | [$wsName!**[#ColumnNext%%|%%2]**2] |
+| Last row with data in column A | [#RowEnd] or #RowEnd | - | [$wsName!C**#RowEnd**] |
 | Last row with data in a specific column | [#RowEnd%%|%%Column] | - | [$wsName!C**#RowEnd%%|%%C**] |
+| First row after the last one with data in column A | [#RowNext] or #RowNext | - | [$wsName!C**#RowNext**] |
+| First row after the last one with data in a specific column | [#RowNext%%|%%Column] | - | [$wsName!C**#RowNext%%|%%C**] |
 | Current row/column of the innermost Row/Column List | [#] or # | - | [$wsName!F**#**] |
 | Current row/column of a specified Row/Column List | [#%%|%%DjeeniName]  | - | [$wsName!F**[#%%|%%rlRowList]**] |
@@ Line 109: / Line 114: @@
 <code>
   [$wsExample!C[#RowEnd|B]]    'the cell in column C that is next to the last cell in column B
+</code>
+===== Next row in a column =====
+You can find the next row after the last one with data in column A by typing **[#RowNext]**. If you are inside a Djeeni formula extension you may leave [] out and type simply **#RowNext**:
+<code>
+  [$wsExample!C#RowNext]    'the cell in Column C that is in the row of the first empty cell in column A
+</code>
+You can refer to the first row after the last one with data of any column by typing **[#RowNext%%|%%ColumnLetter]**:
+<code>
+  [$wsExample!C[#RowNext|B]]    'the cell in column C that is next to the first empty cell in column B
 </code>
@@ Line 123: / Line 142: @@
 <code>
   [$wsExample![#ColumnEnd|4]3]    'the cell in row 3 that is above the last cell in row 4
+</code>
+===== Next column in a row =====
+You can find the first column after the last one with data in row 1 by typing **[#ColumnNext]**. If you are inside a Djeeni formula extension you may leave [] out and type simply **#ColumnNext**:
+<code>
+  [$wsExample!#ColumnNext3]    'the cell in row 3 that is under the first empty cell in row 1
+</code>
+You can refer to the last column of any row by typing **[#ColumnNext%%|%%RowNumber]**:
+<code>
+  [$wsExample![#ColumnNext|4]3]    'the cell in row 3 that is above the first empty cell in row 4
 </code>

User Tools

Site Tools

Differences

Page Tools