harleythecav
New Member
- Joined
- May 18, 2020
- Messages
- 7
- Office Version
- 2016
- Platform
- Windows
Hi Forum
Is there a way for the Transpose formula to return more than the first 255 values?
I seem to be hitting a limit when transposing rows to columns:
{=TRANSPOSE(A2:A258)} with only 255 values returned (even if I increase the range in the formula past A258).
Currently my workaround is starting a new block of columns with the formula having a range starting at the next row which is a bit messy.
I am looking for a formula only solution (if it exists), not VBA (as this workbook gets sent externally and not all allow macro files).
Excel version O365
Thanks
Is there a way for the Transpose formula to return more than the first 255 values?
I seem to be hitting a limit when transposing rows to columns:
{=TRANSPOSE(A2:A258)} with only 255 values returned (even if I increase the range in the formula past A258).
Currently my workaround is starting a new block of columns with the formula having a range starting at the next row which is a bit messy.
I am looking for a formula only solution (if it exists), not VBA (as this workbook gets sent externally and not all allow macro files).
Excel version O365
Thanks