D
ditchy
Hi there excelers, can you help me with this please
colA colB colC colD colE colF colG colH colJ
row1 2 3 4 6 2 8 2 3 average
A:H
row2 6 4 9 5 1 8 1 etc
etc 3 1 2 4 3 etc
etc 2 7 etc
what I need is the average for each row, problem is I would like to
ignore the highest and lowest numbers in that row. Another problem is
that some rows may only have data in 1,2 or 3 cells. Is there a way to
do this?
T.I.A.
regards Ditchy
colA colB colC colD colE colF colG colH colJ
row1 2 3 4 6 2 8 2 3 average
A:H
row2 6 4 9 5 1 8 1 etc
etc 3 1 2 4 3 etc
etc 2 7 etc
what I need is the average for each row, problem is I would like to
ignore the highest and lowest numbers in that row. Another problem is
that some rows may only have data in 1,2 or 3 cells. Is there a way to
do this?
T.I.A.
regards Ditchy