Hello experts,
I have a file consisting of various numbers. When try to edit them formula array is displayed. I want that formula array to be converted into columns.
Example:
In cell A1 I have a number 27 which is a result of formula 12×15×15%. Now I want this formula to be displayed in adjacent cells B1 - 12, C1 - 15 and in D1 - 15%.
Can someone please help me in this.
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
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]
It's not solved. I use mobile application and for every new post it's starts as solved and there is no option to unselect it.
Still waiting for an answer.
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I'm attaching herewith a sample file for reference.
What I want is the numbers displayed in formula array to be displayed in the subsequent columns.
Got the solution. use convert text to columns and select the required fields to be displayed.
But, when a1 cell is selected the value disappears and figures in formula array are split into columns.
Is there any other way that can be used without disturbing the figure in cell A1.
copy it first?
Thank you Martin.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks