Shift list elements to left by 3: Difference between revisions
→{{header|Excel}}: added an Excel LAMBDA version.
(→{{header|Excel}}: added an Excel LAMBDA version.) |
|||
Line 427:
<pre>Original list :[1, 2, 3, 4, 5, 6, 7, 8, 9]
Shifted left by 3 :[4, 5, 6, 7, 8, 9, 1, 2, 3]</pre>
=={{header|Excel}}==
===LAMBDA===
Binding the name '''rotatedRow''' to the following lambda expression in the Name Manager of the Excel WorkBook:
(See [https://www.microsoft.com/en-us/research/blog/lambda-the-ultimatae-excel-worksheet-function/ LAMBDA: The ultimate Excel worksheet function])
{{Works with|Office 365 betas 2021}}
<lang lisp>rotatedRow
=LAMBDA(n,
LAMBDA(xs,
LET(
nCols, COLUMNS(xs),
m, MOD(n, nCols),
x, SEQUENCE(
1, nCols,
1, 1
),
d, nCols - m,
IF(x > d,
x - d,
m + x
)
)
)
)</lang>
{{Out}}
The formula in cell B2 defines an array which populates the whole range '''B2:J2'''
{| class="wikitable"
|-
|||style="text-align:right; font-family:serif; font-style:italic; font-size:120%;"|fx
! colspan="10" style="text-align:left; vertical-align: bottom; font-family:Arial, Helvetica, sans-serif !important;"|=rotatedRow(3)(B1#)
|- style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff;"
|
| A
| B
| C
| D
| E
| F
| G
| H
| I
| J
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 1
| style="font-weight:bold" | List
| style="text-align:right; font-weight:bold" | 1
| style="text-align:right; font-weight:bold" | 2
| style="text-align:right; font-weight:bold" | 3
| style="text-align:right; font-weight:bold" | 4
| style="text-align:right; font-weight:bold" | 5
| style="text-align:right; font-weight:bold" | 6
| style="text-align:right; font-weight:bold" | 7
| style="text-align:right; font-weight:bold" | 8
| style="text-align:right; font-weight:bold" | 9
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 2
| Rotated
| style="text-align:right; background-color:#cbcefb" | 4
| style="text-align:right" | 5
| style="text-align:right" | 6
| style="text-align:right" | 7
| style="text-align:right" | 8
| style="text-align:right" | 9
| style="text-align:right" | 1
| style="text-align:right" | 2
| style="text-align:right" | 3
|}
=={{header|F_Sharp|F#}}==
Line 440 ⟶ 511:
[1; 2; 3]->[]
</pre>
=={{header|Factor}}==
<lang factor> USING: prettyprint sequences.extras ;
| |||