Variable references in a transpose function

[Harry Covair]

Hi the forum,

In a transpose function, I want to use a variable set of references. For example, instead of writing “transpose(c10:c50)”, I want to refer to cells containing the value 10 and 50.

Example

If A10 contains the value 10 and A11, the value 50

I wrote “=transpose(“c”&A10:”c”&A11) but it gives an error message when pressing Ctrl-Shift_Enter.

Do some people have an idea to solve the problem?

Thanks in advance for the answers

Harry

 

[Hui]

Try

=transpose(indirect(“c”&A10:”c”&A11))


You'll need to retype the " 's

 

[Harry Covair]

Hi Hui,

Thanks for your answer.

You "indirectly" solve the problem.

Instead of using your solution as suggested I wrote =TRANSPOSE(INDIRECT("c"&A10):INDIRECT("c"&A11)) which gives the wanted results and the fillhandle can be used.

One a more many thanks

Harry

Post closed