I want to ask expert how transpose formula is used.
In the seven cells there is formula =TRANSPOSE({1;2;3;4;5;6;7}) but the answers has different value with Sun Mon Tue Wed Thu Fri Sat
but when i copy and paste formula from anyone of them it only gave answer 1 equivalent to Sun.
My question is how it happen that the formula =TRANSPOSE({1;2;3;4;5;6;7}) gave different answer? what will i do to copy the formula and the answer is Mon or Tue?
Hello rod bugnay,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks