Using the =TRANSPOSE formula rather than the paste transpose command keeps all your references relative to where you want them... This will save a lot of stress!
IMWA — Mine Water Forum
A forum of the International Mine Water Association about all mine water related subjects
Transposing formulas in Excel
Moderators: Ruth Warrender, Andy Barnes
1 post
• Page 1 of 1
Transposing formulas in Excel
by Andy Barnes » 2009-11-13, 23:53
If like me you have ever been frustrated by that the paste transpose function in Excel messing up your formulas, don't panic. I found this useful tip on the internet for getting around the problem.
Using the =TRANSPOSE formula rather than the paste transpose command keeps all your references relative to where you want them... This will save a lot of stress!
Using the =TRANSPOSE formula rather than the paste transpose command keeps all your references relative to where you want them... This will save a lot of stress!
Mine Water Enthusiast!
- Andy Barnes
- Site Admin
- Posts: 52
- Joined: 2009-05-03, 20:23
- Location: Abergavenny, Wales, UK
1 post
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 5 guests