# 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)

## Files

• 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

• ## CarimApr 15th 2023

• Thanks to Rollis13 for reporting CROSS POST

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 ().

• ## CarimApr 15th 2023

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 :

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

• Attached is your test file

## Files

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!