can't seem to use TRANSPOSE formula

  • Thread starter Thread starter Clarence Andre
  • Start date Start date
C

Clarence Andre

Hi,

I can't seem to get the TRANSPOSE formula to work. As I
understand the TRANSPOSE formula transposes an array, say
a column of numbers into a row.

However when I tried doing that, I'm getting "#VALUE!"
which appears like an error message.

Can you kindly advise on how I can get the TRANSPOSE
formula to work? I'm on Excel 97 and I've seen this
formula work on other spreadsheets.

Clarence
 
Clarence Andre -
I can't seem to get the TRANSPOSE formula to work. As I understand the
Click to expand...
TRANSPOSE formula transposes an array, say a column of numbers into a row.
However when I tried doing that, I'm getting "#VALUE!" which appears like an
error message. Can you kindly advise on how I can get the TRANSPOSE formula
to work? I'm on Excel 97 and I've seen this formula work on other
spreadsheets. <

For example, enter the values 1,2,3 into cells A1:A3. Select cells C1:E1.
Type =TRANSPOSE(A1:A3) but don't press Enter. Instead, hold down Control and
Shift while you press Enter (thus "array entering" the formula).

- Mike Middleton, www.usfca.edu/~middleton
 
Back
Top