Hi Everyone.

I am currently using excel to process some data. The data is a long list having 60,000 rows by 96 columns. This is why I need your help.

To give an example of what I need to do is as follows.

Say I have 5 matrices being of different number of rows but always 96 columns. For example 5,10,12,8,15 rows respectively. So the matrix size are not uniform.

The first Column is the date dd/mm/yyyy and I need to find the geometric mean of the 5 matrices but being sorted by the same date and column. The operation I need is similar to the Consolidation. But the consolidation only finds the arithmetic mean but I need the geometric mean.

Can someone help me please?

Thanking you in advance,