How to Find in Excel the total count of how many times each banks increase interest rate?

Kiko22

New Member
Joined
Apr 15, 2023
Messages
5
Office Version
  1. 2016
Platform
  1. Windows
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)
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Are you saying that column D contains the new Interest Rate that applies from 1/11/2022?

Is the date used as the column header?

Do you just keep adding columns as you go into the future?

Can we please see an example of your data?
 
Upvote 0
ProviderProductMarket1/11/20222/11/20223/11/20224/11/20225/11/20226/11/20227/11/20228/11/20229/11/202210/11/202211/11/202212/11/202213/11/202214/11/202215/11/202216/11/202217/11/202218/11/202219/11/202220/11/202221/11/202222/11/202223/11/202224/11/202225/11/202226/11/202227/11/202228/11/202229/11/202230/11/202231/11/2022Total IncreasesTotal DecreasesTotal No Changes
Gatehouse BankEasy Access AccountInstant Access3.203.203.203.203.203.203.203.203.20
Al Rayan BankEveryday Saver (Issue 3)Instant Access2.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.813.223.303.303.303.303.303.303.363.36
Shawbrook BankEasy Access - Issue 30Instant Access2.302.302.302.302.302.302.302.302.302.302.302.302.302.302.302.302.302.302.302.302.302.30
Cynergy BankOnline Easy Access Account (Issue 58)Instant Access2.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.753.253.253.253.253.253.253.253.253.25
ZopaSmart SaverInstant Access2.402.402.402.402.402.402.402.402.402.402.402.862.862.862.862.862.862.862.862.862.862.863.213.213.213.343.343.343.343.343.34
Paragon BankTriple Access Savings Account - Issue 10 0-3 withdrawals paInstant Access
UBL UKRaisin UK - Easy Access AccountInstant Access2.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.952.952.952.952.952.95
Charter Savings BankEasy Access - Issue 36Instant Access2.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.353.183.183.183.183.183.183.183.303.30
Nationwide BS1 Year Triple Access Online Saver 15 0-3 withdrawals paInstant Access2.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.503.003.003.003.003.003.00
 
Upvote 0
Sample Workbook data.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAK
1ProviderProductMarket1/11/20222/11/20223/11/20224/11/20225/11/20226/11/20227/11/20228/11/20229/11/202210/11/202211/11/202212/11/202213/11/202214/11/202215/11/202216/11/202217/11/202218/11/202219/11/202220/11/202221/11/202222/11/202223/11/202224/11/202225/11/202226/11/202227/11/202228/11/202229/11/202230/11/202231/11/2022Total IncreasesTotal DecreasesTotal No Changes
2Gatehouse BankEasy Access AccountInstant Access3.203.203.203.203.203.203.203.203.20
3Al Rayan BankEveryday Saver (Issue 3)Instant Access2.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.813.223.303.303.303.303.303.303.363.36
4Shawbrook BankEasy Access - Issue 30Instant Access2.302.302.302.302.302.302.302.302.302.302.302.302.302.302.302.302.302.302.302.302.302.30
5Cynergy BankOnline Easy Access Account (Issue 58)Instant Access2.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.753.253.253.253.253.253.253.253.253.25
6ZopaSmart SaverInstant Access2.402.402.402.402.402.402.402.402.402.402.402.862.862.862.862.862.862.862.862.862.862.863.213.213.213.343.343.343.343.343.34
7Paragon BankTriple Access Savings Account - Issue 10 0-3 withdrawals paInstant Access
8UBL UKRaisin UK - Easy Access AccountInstant Access2.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.952.952.952.952.952.95
9Charter Savings BankEasy Access - Issue 36Instant Access2.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.353.183.183.183.183.183.183.183.303.30
10Nationwide BS1 Year Triple Access Online Saver 15 0-3 withdrawals paInstant Access2.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.502.503.003.003.003.003.003.00
Sheet1
 
Upvote 0
Are you saying that column D contains the new Interest Rate that applies from 1/11/2022?

Is the date used as the column header?

Do you just keep adding columns as you go into the future?

Can we please see an example of your data?
I have posted the sample of the sheet
 
Upvote 0
Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to Find in Excel the total count of how many times each banks increase interest rate? Please if any one can help please
and Calculate the total Count of Consecutive Increases /Decreases - OzGrid Free Excel/VBA Help Forum

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 
Upvote 0
What are your expected results?
try the following
T202304a.xlsm
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI
1ProviderProductMarket01-11-2202-11-2203-11-2204-11-2205-11-2206-11-2207-11-2208-11-2209-11-2210-11-2211-11-2212-11-2213-11-2214-11-2215-11-2216-11-2217-11-2218-11-2219-11-2220-11-2221-11-2222-11-2223-11-2224-11-2225-11-2226-11-2227-11-2228-11-2229-11-2230-11-2231/11/2022Total Increases
2Gatehouse BankEasy Access AccountInstant Access3.23.23.23.23.23.23.23.23.20
3Al Rayan BankEveryday Saver (Issue 3)Instant Access2.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.813.223.33.33.33.33.33.33.363.363
4Shawbrook BankEasy Access - Issue 30Instant Access2.32.32.32.32.32.32.32.32.32.32.32.32.32.32.32.32.32.32.32.32.32.30
5Cynergy BankOnline Easy Access Account (Issue 58)Instant Access2.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.753.253.253.253.253.253.253.253.253.251
6ZopaSmart SaverInstant Access2.42.42.42.42.42.42.42.42.42.42.42.862.862.862.862.862.862.862.862.862.862.863.213.213.213.343.343.343.343.343.343
7Paragon BankTriple Access Savings Account - Issue 10 0-3 withdrawals paInstant Access0
8UBL UKRaisin UK - Easy Access AccountInstant Access2.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.952.952.952.952.952.951
9Charter Savings BankEasy Access - Issue 36Instant Access2.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.353.183.183.183.183.183.183.183.33.32
10Nationwide BS1 Year Triple Access Online Saver 15 0-3 withdrawals paInstant Access2.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.53333331
3d
Cell Formulas
RangeFormula
AI2:AI10AI2=IF(COUNT(D2:AH2)=0,0,SUMPRODUCT(--(E2:AH2>D2:AG2))-(D2=""))
 
Upvote 0
What are your expected results?
try the following
T202304a.xlsm
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI
1ProviderProductMarket01-11-2202-11-2203-11-2204-11-2205-11-2206-11-2207-11-2208-11-2209-11-2210-11-2211-11-2212-11-2213-11-2214-11-2215-11-2216-11-2217-11-2218-11-2219-11-2220-11-2221-11-2222-11-2223-11-2224-11-2225-11-2226-11-2227-11-2228-11-2229-11-2230-11-2231/11/2022Total Increases
2Gatehouse BankEasy Access AccountInstant Access3.23.23.23.23.23.23.23.23.20
3Al Rayan BankEveryday Saver (Issue 3)Instant Access2.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.812.813.223.33.33.33.33.33.33.363.363
4Shawbrook BankEasy Access - Issue 30Instant Access2.32.32.32.32.32.32.32.32.32.32.32.32.32.32.32.32.32.32.32.32.32.30
5Cynergy BankOnline Easy Access Account (Issue 58)Instant Access2.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.752.753.253.253.253.253.253.253.253.253.251
6ZopaSmart SaverInstant Access2.42.42.42.42.42.42.42.42.42.42.42.862.862.862.862.862.862.862.862.862.862.863.213.213.213.343.343.343.343.343.343
7Paragon BankTriple Access Savings Account - Issue 10 0-3 withdrawals paInstant Access0
8UBL UKRaisin UK - Easy Access AccountInstant Access2.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.252.952.952.952.952.952.951
9Charter Savings BankEasy Access - Issue 36Instant Access2.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.352.353.183.183.183.183.183.183.183.33.32
10Nationwide BS1 Year Triple Access Online Saver 15 0-3 withdrawals paInstant Access2.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.52.53333331
3d
Cell Formulas
RangeFormula
AI2:AI10AI2=IF(COUNT(D2:AH2)=0,0,SUMPRODUCT(--(E2:AH2>D2:AG2))-(D2=""))
Thank You
 
Upvote 0
Hi,
Not sure to understand your request :
Do you need for each institution: the Total Number of Increases, the Total Number of Decreases and the Total Number of NoChanges ...???
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top