Hello, I have a line that starts off with a steady increasing slope but suddenly jumps to a very steep slope. My problem is that I need to figure out the exact point (x-axis) where that change occurs. Can anyone help with a formula or function? I already know how to solve both exact slopes, I just do not know how to find that exact point.
Assuming you have a data table that is in A2:B50, you could put this formula starting in C3 and copying down.
=B3-B2
Then you could just apply a filter and look for the largest change.
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks