Calculate the total Count of Consecutive Increases /Decreases

    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question



    Hi, please if anyone can help.



    I have dataset of all the interest rate.



    I want to find the formula for excel, I want to know total count of How many times each banks increase interest rate in a one-month periods, how many times each banks decrease interest rate in a one-month periods, how many times each banks kept interest rate same in a one-month periods. I have data is of 1 month period.




    This below column formula I am trying to find if anyone can help me. Thanks in advance.



    Column AH = Total Increase (Need Excel formula to find this)


    Column AI = Total Decrease (Need Excel formula to find this)


    Column AJ = Total No Changes (Need Excel formula to find this)



    My data column is structure as following



    Column A = Provider (Bank Name)


    Column B = Product Name


    Column C = Market Name


    Column D = 1/11/2022 (Interest Rate Data)


    Column E = 2/11/2022 (Interest Rate Data)


    Column F = 3/11/2022 (Interest Rate Data)


    Column G = 4/11/2022 (Interest Rate Data)


    Column H = 5/11/2022 (Interest Rate Data)


    Column I = 6/11/2022 (Interest Rate Data)


    Column J = 7/11/2022 (Interest Rate Data)


    Column K = 8/11/2022 (Interest Rate Data)


    Column L = 9/11/2022 (Interest Rate Data)


    Column M = 10/11/2022 (Interest Rate Data)


    Column N = 11/11/2022 (Interest Rate Data)


    Column O = 12/11/2022 (Interest Rate Data)


    Column P = 13/11/2022 (Interest Rate Data)


    Column Q = 14/11/2022 (Interest Rate Data)


    Column R = 15/11/2022 (Interest Rate Data)


    Column S = 16/11/2022 (Interest Rate Data)


    Column T = 17/11/2022 (Interest Rate Data)


    Column U = 18/11/2022 (Interest Rate Data)


    Column V = 19/11/2022 (Interest Rate Data)


    Column W = 20/11/2022 (Interest Rate Data)


    Column X = 21/11/2022 (Interest Rate Data)


    Column Y = 22/11/2022 (Interest Rate Data)


    Column Z = 23/11/2022 (Interest Rate Data)


    Column AA = 24/11/2022 (Interest Rate Data)


    Column AB = 25/11/2022 (Interest Rate Data)


    Column AC = 26/11/2022 (Interest Rate Data)


    Column AD = 27/11/2022 (Interest Rate Data)


    Column AE = 28/11/2022 (Interest Rate Data)


    Column AF = 29/11/2022 (Interest Rate Data)


    Column AG = 30/11/2022 (Interest Rate Data)

    Hi and Welcome to the Forum :)


    Regarding your question, in order to simplify things,, would you accept a solution based on a UDF (User Defined Function) ?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Carim

    Added the Label Cross Post

    Thanks to Rollis13 for reporting CROSS POST


    Missing crosspost link:


    chandoo.org/forum/threads/how-…ne-can-help-please.52571/


    Another Missing crosspost link :


    How to Find in Excel the total count of how many times each banks increase interest rate?
    Hi, please if anyone can help. I have dataset of all the interest rate. I want to find the formula for excel, I want to know total count of How many…
    www.mrexcel.com

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Edited once, last by Carim: Missing CROSSPOST Link ().

  • Carim

    Changed the title of the thread from “How to Find in Excel the total count of how many times each banks increase interest rate? Please if any one can help please” to “Calculate the total Count of Consecutive Increases /Decreases”.

    Hi again,


    Make sure to read the Forum rules :


    Thread
    Forum Rules

    THREAD TITLES

    1a. Thread titles MUST aptly and concisely describe your problem.
    1b. Your title must describe your problem, not your anticipated solution.
    1c. Use terms suitable to a Google search and do not use words like "Please Help", "Urgent", "Excel Problem"
    1d. Do not use Excel formulas in thread titles. E.g. "Help with VLOOKUP" (you have assumed the solution to your problem involves VLOOKUP).

    Why? All of the above makes your code search engine friendly and easier for other people with…
    S O


    Thanks

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login