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

[Kiko22]

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)

 

[Herakles]

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?

 

[Kiko22]

Provider	Product	Market	1/11/2022	2/11/2022	3/11/2022	4/11/2022	5/11/2022	6/11/2022	7/11/2022	8/11/2022	9/11/2022	10/11/2022	11/11/2022	12/11/2022	13/11/2022	14/11/2022	15/11/2022	16/11/2022	17/11/2022	18/11/2022	19/11/2022	20/11/2022	21/11/2022	22/11/2022	23/11/2022	24/11/2022	25/11/2022	26/11/2022	27/11/2022	28/11/2022	29/11/2022	30/11/2022	31/11/2022	Total Increases	Total Decreases	Total No Changes
Gatehouse Bank	Easy Access Account	Instant Access																							3.20	3.20	3.20	3.20	3.20	3.20	3.20	3.20	3.20
Al Rayan Bank	Everyday Saver (Issue 3)	Instant Access	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	3.22	3.30	3.30	3.30	3.30	3.30	3.30	3.36	3.36
Shawbrook Bank	Easy Access - Issue 30	Instant Access	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30
Cynergy Bank	Online Easy Access Account (Issue 58)	Instant Access	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	3.25	3.25	3.25	3.25	3.25	3.25	3.25	3.25	3.25
Zopa	Smart Saver	Instant Access	2.40	2.40	2.40	2.40	2.40	2.40	2.40	2.40	2.40	2.40	2.40	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	3.21	3.21	3.21	3.34	3.34	3.34	3.34	3.34	3.34
Paragon Bank	Triple Access Savings Account - Issue 10 0-3 withdrawals pa	Instant Access
UBL UK	Raisin UK - Easy Access Account	Instant Access	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.95	2.95	2.95	2.95	2.95	2.95
Charter Savings Bank	Easy Access - Issue 36	Instant Access	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	3.18	3.18	3.18	3.18	3.18	3.18	3.18	3.30	3.30
Nationwide BS	1 Year Triple Access Online Saver 15 0-3 withdrawals pa	Instant Access	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	3.00	3.00	3.00	3.00	3.00	3.00

 

[Kiko22]

Sample Workbook data.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK
1	Provider	Product	Market	1/11/2022	2/11/2022	3/11/2022	4/11/2022	5/11/2022	6/11/2022	7/11/2022	8/11/2022	9/11/2022	10/11/2022	11/11/2022	12/11/2022	13/11/2022	14/11/2022	15/11/2022	16/11/2022	17/11/2022	18/11/2022	19/11/2022	20/11/2022	21/11/2022	22/11/2022	23/11/2022	24/11/2022	25/11/2022	26/11/2022	27/11/2022	28/11/2022	29/11/2022	30/11/2022	31/11/2022	Total Increases	Total Decreases	Total No Changes
2	Gatehouse Bank	Easy Access Account	Instant Access																							3.20	3.20	3.20	3.20	3.20	3.20	3.20	3.20	3.20
3	Al Rayan Bank	Everyday Saver (Issue 3)	Instant Access	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	3.22	3.30	3.30	3.30	3.30	3.30	3.30	3.36	3.36
4	Shawbrook Bank	Easy Access - Issue 30	Instant Access	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30	2.30
5	Cynergy Bank	Online Easy Access Account (Issue 58)	Instant Access	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	3.25	3.25	3.25	3.25	3.25	3.25	3.25	3.25	3.25
6	Zopa	Smart Saver	Instant Access	2.40	2.40	2.40	2.40	2.40	2.40	2.40	2.40	2.40	2.40	2.40	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	3.21	3.21	3.21	3.34	3.34	3.34	3.34	3.34	3.34
7	Paragon Bank	Triple Access Savings Account - Issue 10 0-3 withdrawals pa	Instant Access
8	UBL UK	Raisin UK - Easy Access Account	Instant Access	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.95	2.95	2.95	2.95	2.95	2.95
9	Charter Savings Bank	Easy Access - Issue 36	Instant Access	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	3.18	3.18	3.18	3.18	3.18	3.18	3.18	3.30	3.30
10	Nationwide BS	1 Year Triple Access Online Saver 15 0-3 withdrawals pa	Instant Access	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	2.50	3.00	3.00	3.00	3.00	3.00	3.00
Sheet1

 

[Kiko22]

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

 

[Fluff]

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.

 

[Dave Patton]

What are your expected results?
try the following

T202304a.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI
1	Provider	Product	Market	01-11-22	02-11-22	03-11-22	04-11-22	05-11-22	06-11-22	07-11-22	08-11-22	09-11-22	10-11-22	11-11-22	12-11-22	13-11-22	14-11-22	15-11-22	16-11-22	17-11-22	18-11-22	19-11-22	20-11-22	21-11-22	22-11-22	23-11-22	24-11-22	25-11-22	26-11-22	27-11-22	28-11-22	29-11-22	30-11-22	31/11/2022	Total Increases
2	Gatehouse Bank	Easy Access Account	Instant Access																							3.2	3.2	3.2	3.2	3.2	3.2	3.2	3.2	3.2	0
3	Al Rayan Bank	Everyday Saver (Issue 3)	Instant Access	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	3.22	3.3	3.3	3.3	3.3	3.3	3.3	3.36	3.36	3
4	Shawbrook Bank	Easy Access - Issue 30	Instant Access	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3										0
5	Cynergy Bank	Online Easy Access Account (Issue 58)	Instant Access	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	3.25	3.25	3.25	3.25	3.25	3.25	3.25	3.25	3.25	1
6	Zopa	Smart Saver	Instant Access	2.4	2.4	2.4	2.4	2.4	2.4	2.4	2.4	2.4	2.4	2.4	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	3.21	3.21	3.21	3.34	3.34	3.34	3.34	3.34	3.34	3
7	Paragon Bank	Triple Access Savings Account - Issue 10 0-3 withdrawals pa	Instant Access																																0
8	UBL UK	Raisin UK - Easy Access Account	Instant Access	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.95	2.95	2.95	2.95	2.95	2.95	1
9	Charter Savings Bank	Easy Access - Issue 36	Instant Access	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	3.18	3.18	3.18	3.18	3.18	3.18	3.18	3.3	3.3	2
10	Nationwide BS	1 Year Triple Access Online Saver 15 0-3 withdrawals pa	Instant Access	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	3	3	3	3	3	3	1
3d

Cell Formulas
Range	Formula
AI2:AI10	AI2	=IF(COUNT(D2:AH2)=0,0,SUMPRODUCT(--(E2:AH2>D2:AG2))-(D2=""))

 

[Kiko22]

What are your expected results?
try the following

T202304a.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI
1	Provider	Product	Market	01-11-22	02-11-22	03-11-22	04-11-22	05-11-22	06-11-22	07-11-22	08-11-22	09-11-22	10-11-22	11-11-22	12-11-22	13-11-22	14-11-22	15-11-22	16-11-22	17-11-22	18-11-22	19-11-22	20-11-22	21-11-22	22-11-22	23-11-22	24-11-22	25-11-22	26-11-22	27-11-22	28-11-22	29-11-22	30-11-22	31/11/2022	Total Increases
2	Gatehouse Bank	Easy Access Account	Instant Access																							3.2	3.2	3.2	3.2	3.2	3.2	3.2	3.2	3.2	0
3	Al Rayan Bank	Everyday Saver (Issue 3)	Instant Access	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	2.81	3.22	3.3	3.3	3.3	3.3	3.3	3.3	3.36	3.36	3
4	Shawbrook Bank	Easy Access - Issue 30	Instant Access	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3	2.3										0
5	Cynergy Bank	Online Easy Access Account (Issue 58)	Instant Access	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	2.75	3.25	3.25	3.25	3.25	3.25	3.25	3.25	3.25	3.25	1
6	Zopa	Smart Saver	Instant Access	2.4	2.4	2.4	2.4	2.4	2.4	2.4	2.4	2.4	2.4	2.4	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	2.86	3.21	3.21	3.21	3.34	3.34	3.34	3.34	3.34	3.34	3
7	Paragon Bank	Triple Access Savings Account - Issue 10 0-3 withdrawals pa	Instant Access																																0
8	UBL UK	Raisin UK - Easy Access Account	Instant Access	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.25	2.95	2.95	2.95	2.95	2.95	2.95	1
9	Charter Savings Bank	Easy Access - Issue 36	Instant Access	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	2.35	3.18	3.18	3.18	3.18	3.18	3.18	3.18	3.3	3.3	2
10	Nationwide BS	1 Year Triple Access Online Saver 15 0-3 withdrawals pa	Instant Access	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	2.5	3	3	3	3	3	3	1
3d

Cell Formulas
Range	Formula
AI2:AI10	AI2	=IF(COUNT(D2:AH2)=0,0,SUMPRODUCT(--(E2:AH2>D2:AG2))-(D2=""))

Thank You

 

[Dave Patton]

Thanks for the feedback

 

[James006]

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 ...???