C
carl
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%
Is it possible for a formula to look at the BOXID and the 2nd and 3rd
characters of the first row above and average the values. The result table
would look like this (formula would be in B23):
01 02 06
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%
Is it possible for a formula to look at the BOXID and the 2nd and 3rd
characters of the first row above and average the values. The result table
would look like this (formula would be in B23):
01 02 06
BOX005 15.25% 0.00% 0.00%
BOX017 15.25% 0.00% 21.52%
Thank you in advance.