How to count of times each banks increase interest rate?

[Kiko]

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)

I have attached small excel workbook. If anyone can help with this formula. Thanks in advance.

 

[vletm]

Kiko
How about to see - how do those change?

Ps. November has 30 days.

 

[Kiko]

Kiko
How about to see - how do those change?
View attachment 83863
Ps. November has 30 days.

This is only sample data to for the formula

 

[vletm]

Kiko
How to know, which data belongs to one month, if Your the 1st row values are something else than dates?
Could You show Your expected result per Your sample data?

 

[AlanSidman]

Crossposted to MrE and OzGrid. Reported.

 

[vletm]

Kiko
Please, reread and follow Forum Rules - those are for You too:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.