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