Percentage Retention

[Rosario]

Hi, I need help please, I'm trying to get "Result expected" calculated from the table as shown below, ei; Year 2023 Column E / Year 2019 Column A =  101.27%:

Year	A	B	C	D	E	F	G	H	I	J	K	L	M
2023	237	272	252	227	239	191	205	207	194	161	133	133	99
2022	280	262	231	236	214	208	221	200	171	144	139	105	98
2021	264	237	235	212	208	222	201	189	154	161	116	109	112
2020	235	241	203	216	222	208	189	156	168	126	117	121	87
2019	236	191	204	219	212	194	165	168	135	126	129	92	66
	2023E/2019A	2023G/2019E	2023M/2019I	2012M/2019P
Result expected	101.27%	96.70%	73.33%	76.74%

Many thanks. Rosario.

[lbendlin · Accepted solution]

Your expected results are inconsistent but here is one version

[Rosario]

Hi, Thanks for your support, it helps for the first result. I know there are inconsistencies, and it was we really are after. You help gave me an idea on how to get the other reuslts. I will try and see if it works. Thank You. Rosario.