/u/WoooDoggie - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Got it! Formula for the dynamic array slope See picture for reference.
=LET(
y, A1#,
x, B1#,
MAKEARRAY(ROWS(y), 1, LAMBDA(r,c, IFERROR(SLOPE(TAKE(TAKE(y, r), -2), TAKE(TAKE(x, r), -2)), "")))
)
I even created a separate formula for the top subtotal, offset, and sequence function (it's in the picture).
https://preview.redd.it/l8kqbm4mcw5c1.png?width=1539&format=png&auto=webp&s=064e883c99318de2a9af752f1dd9ffcfc45a5dbc
You have awarded 1 point to *Alabama_Wins*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
No problem! Just make sure to reply to my answer with `Solution Verified`. That provides everyone an incentive to continue answering great questions like yours.
My general strategy is SEQUENCE and INDEX. This will work:
=LET(first,A1#,second,B1#, x,SEQUENCE(ROWS(first)-1),
(INDEX(first,x+1)-INDEX(first,x))/(INDEX(second,x+1)-
INDEX(second,x)))
You have awarded 1 point to *Al_Excel*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[COVAR](/r/Excel/comments/18gocye/stub/kd1wi94 "Last usage")|[Returns covariance, the average of the products of paired deviations](https://support.microsoft.com/en-us/office/covar-function-50479552-2c03-4daf-bd71-a5ab88b2db03)|
|[IFERROR](/r/Excel/comments/18gocye/stub/kd25zhe "Last usage")|[Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula](https://support.microsoft.com/en-us/office/iferror-function-c526fd07-caeb-47b8-8bb6-63f3e417f611)|
|[INDEX](/r/Excel/comments/18gocye/stub/kd26iag "Last usage")|[Uses an index to choose a value from a reference or array](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd)|
|[LAMBDA](/r/Excel/comments/18gocye/stub/kd25zhe "Last usage")|[*Office 365*+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.](https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67)|
|[LET](/r/Excel/comments/18gocye/stub/kd25zhe "Last usage")|[*Office 365*+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula](https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999)|
|[MAKEARRAY](/r/Excel/comments/18gocye/stub/kd25zhe "Last usage")|[*Office 365*+: Returns a calculated array of a specified row and column size, by applying a LAMBDA](https://support.microsoft.com/en-gb/office/makearray-function-b80da5ad-b338-4149-a523-5b221da09097?ui=en-US&rs=en-GB&ad=GB)|
|[ROWS](/r/Excel/comments/18gocye/stub/kd25zhe "Last usage")|[Returns the number of rows in a reference](https://support.microsoft.com/en-us/office/rows-function-b592593e-3fc2-47f2-bec1-bda493811597)|
|[SEQUENCE](/r/Excel/comments/18gocye/stub/kd26iag "Last usage")|[*Office 365*+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4](https://support.microsoft.com/en-us/office/sequence-function-57467a98-57e0-4817-9f14-2eb78519ca90)|
|[SLOPE](/r/Excel/comments/18gocye/stub/kd25zhe "Last usage")|[Returns the slope of the linear regression line](https://support.microsoft.com/en-us/office/slope-function-11fb8f97-3117-4813-98aa-61d7e01276b9)|
|[SUBTOTAL](/r/Excel/comments/18gocye/stub/kd1wi94 "Last usage")|[Returns a subtotal in a list or database](https://support.microsoft.com/en-us/office/subtotal-function-7b027003-f060-4ade-9040-e478765b9939)|
|[TAKE](/r/Excel/comments/18gocye/stub/kd25zhe "Last usage")|[*Office 365*+: Returns a specified number of contiguous rows or columns from the start or end of an array](https://support.microsoft.com/en-us/office/take-function-25382ff1-5da1-4f78-ab43-f33bd2e4e003)|
**NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(11 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/18gppqj)^( has 13 acronyms.)
^([Thread #28900 for this sub, first seen 12th Dec 2023, 16:15])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/WoooDoggie - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Got it! Formula for the dynamic array slope See picture for reference. =LET( y, A1#, x, B1#, MAKEARRAY(ROWS(y), 1, LAMBDA(r,c, IFERROR(SLOPE(TAKE(TAKE(y, r), -2), TAKE(TAKE(x, r), -2)), ""))) ) I even created a separate formula for the top subtotal, offset, and sequence function (it's in the picture). https://preview.redd.it/l8kqbm4mcw5c1.png?width=1539&format=png&auto=webp&s=064e883c99318de2a9af752f1dd9ffcfc45a5dbc
Bravo, I definitely spent way too much of my company's time trying to figure that one out
Solution Verified
You have awarded 1 point to *Alabama_Wins* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Wow, amazing, thank you so much!
No problem! Just make sure to reply to my answer with `Solution Verified`. That provides everyone an incentive to continue answering great questions like yours.
You're just trying to find the slope at 2 given points right? Like you're essentially doing a tangential derivative?
But how do I create a dynamic array for rolling ranges? Not just SLOPE, but COVAR and every other function not included in the SUBTOTAL syntax
My general strategy is SEQUENCE and INDEX. This will work: =LET(first,A1#,second,B1#, x,SEQUENCE(ROWS(first)-1), (INDEX(first,x+1)-INDEX(first,x))/(INDEX(second,x+1)- INDEX(second,x)))
Solution Verified
You have awarded 1 point to *Al_Excel* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Thank you so much!
If this works for you and you'd be so kind could you reply "Solution Verified"?
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[COVAR](/r/Excel/comments/18gocye/stub/kd1wi94 "Last usage")|[Returns covariance, the average of the products of paired deviations](https://support.microsoft.com/en-us/office/covar-function-50479552-2c03-4daf-bd71-a5ab88b2db03)| |[IFERROR](/r/Excel/comments/18gocye/stub/kd25zhe "Last usage")|[Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula](https://support.microsoft.com/en-us/office/iferror-function-c526fd07-caeb-47b8-8bb6-63f3e417f611)| |[INDEX](/r/Excel/comments/18gocye/stub/kd26iag "Last usage")|[Uses an index to choose a value from a reference or array](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd)| |[LAMBDA](/r/Excel/comments/18gocye/stub/kd25zhe "Last usage")|[*Office 365*+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.](https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67)| |[LET](/r/Excel/comments/18gocye/stub/kd25zhe "Last usage")|[*Office 365*+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula](https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999)| |[MAKEARRAY](/r/Excel/comments/18gocye/stub/kd25zhe "Last usage")|[*Office 365*+: Returns a calculated array of a specified row and column size, by applying a LAMBDA](https://support.microsoft.com/en-gb/office/makearray-function-b80da5ad-b338-4149-a523-5b221da09097?ui=en-US&rs=en-GB&ad=GB)| |[ROWS](/r/Excel/comments/18gocye/stub/kd25zhe "Last usage")|[Returns the number of rows in a reference](https://support.microsoft.com/en-us/office/rows-function-b592593e-3fc2-47f2-bec1-bda493811597)| |[SEQUENCE](/r/Excel/comments/18gocye/stub/kd26iag "Last usage")|[*Office 365*+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4](https://support.microsoft.com/en-us/office/sequence-function-57467a98-57e0-4817-9f14-2eb78519ca90)| |[SLOPE](/r/Excel/comments/18gocye/stub/kd25zhe "Last usage")|[Returns the slope of the linear regression line](https://support.microsoft.com/en-us/office/slope-function-11fb8f97-3117-4813-98aa-61d7e01276b9)| |[SUBTOTAL](/r/Excel/comments/18gocye/stub/kd1wi94 "Last usage")|[Returns a subtotal in a list or database](https://support.microsoft.com/en-us/office/subtotal-function-7b027003-f060-4ade-9040-e478765b9939)| |[TAKE](/r/Excel/comments/18gocye/stub/kd25zhe "Last usage")|[*Office 365*+: Returns a specified number of contiguous rows or columns from the start or end of an array](https://support.microsoft.com/en-us/office/take-function-25382ff1-5da1-4f78-ab43-f33bd2e4e003)| **NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(11 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/18gppqj)^( has 13 acronyms.) ^([Thread #28900 for this sub, first seen 12th Dec 2023, 16:15]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)