G
Guest
My data table looks like this:
BOXID 60103 60101 60622 60626
BOX005 0.00% 30.51% 0.00% 0.00%
BOX009 0.05% 0.53% 0.01% 0.00%
BOX017 16.31% 14.20% 19.71% 23.34%
BOX050 0.19% 0.02% 1.92% 0.88%
BOX060 0.00% 0.00% 0.00% 0.00%
BOX074 0.00% 0.00% 0.00% 0.00%
I am trying to find a formula that will give the average of the data
relating to the BOXID and the 2nd and 3rd characters of row 1 of the data
table. The result would be like this for example.
1 2 6
BOX005 15.25% 0.00% 0.00%
BOX017 15.25% 0.00% 21.52%
Thank you in advance.
BOXID 60103 60101 60622 60626
BOX005 0.00% 30.51% 0.00% 0.00%
BOX009 0.05% 0.53% 0.01% 0.00%
BOX017 16.31% 14.20% 19.71% 23.34%
BOX050 0.19% 0.02% 1.92% 0.88%
BOX060 0.00% 0.00% 0.00% 0.00%
BOX074 0.00% 0.00% 0.00% 0.00%
I am trying to find a formula that will give the average of the data
relating to the BOXID and the 2nd and 3rd characters of row 1 of the data
table. The result would be like this for example.
1 2 6
BOX005 15.25% 0.00% 0.00%
BOX017 15.25% 0.00% 21.52%
Thank you in advance.