我有所有利率的数据集。
我想找到Excel的公式,我想知道每个银行在一个月内增加多少次利率的总数,每个银行在一个月内减少多少次利率,每个银行在一个月内保持利率不变的次数。我有一个月的数据。
我已经尝试了不同的公式,但它的未来错误或错误的数字
这是当前色谱柱设置:
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 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)
3条答案
按热度按时间k3bvogb11#
这将计算从前一天开始汇率变化的次数。
对于单元格AH 2-速率增加多少倍:
对于单元格AI 2-速率降低了多少次:
对于单元格AJ 2-速率未更改的次数:
vnzz0bqm2#
增减(Excel公式)
整个范围
单行
wribegjk3#
对于AH列(总增量):
对于列AI(总减少):
对于AJ列(总计无变更):