Extract a column/row from a 2-D array

[Fred Chow]

Dear all,

Just want to know if there are easy ways to extract a row or a column of a
2-D way (except writing custom functions to achieve this). so that, for
instance, I could average a row or column of an array easily.

Thanks for your assitance in advance.

Frederick Chow
Hong Kong.

 

[Alan Beban]

Dear all,

Just want to know if there are easy ways to extract a row or a column of a
2-D way (except writing custom functions to achieve this). so that, for
instance, I could average a row or column of an array easily.

Thanks for your assitance in advance.

Frederick Chow
Hong Kong.

What version of Excel?

Alan Beban