I want find way how to Data type array change
Can you help me?
Thanks and Sorry for my Bad English
change.xlsx
Change.xlsx file is example sheet
its work on VBA
I want find way how to Data type array change
Can you help me?
Thanks and Sorry for my Bad English
change.xlsx
Change.xlsx file is example sheet
its work on VBA
Last edited by system0; 12-11-2013 at 05:04 AM.
Please upload your sample workbook to the forum. Not all members are able (or willing) to download files from file-hosting sites.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Perhaps you could explain how you arrived at the values you did?
Yoy go from...
E F G H I J K 11 source option1 option2 option3 option4 option5 12 13 1 4 6 10 25 14 1 a 0 1 0 1 0
to...
N O P Q R S 12 changed option1 value1 option2 value2 13 14 1 a 4 1 10 1 15 2 b 1 10 4 1
hi there. don't really understand the explanation, but this seems to give you what you want. 2 different array formulas in P14 & Q14
=IFERROR(INDEX($G$13:$K$13,SMALL(IF($G14:$K14>0,COLUMN($G14:$K14)),COUNTIF($P$12:P$12,"option*"))-COLUMN($G14)+1),"")
=IFERROR(INDEX($G14:$K14,SMALL(IF($G14:$K14>0,COLUMN($G14:$K14)),COUNTIF($Q$12:Q$12,"value*"))-COLUMN($G14)+1),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
copy both formulas & paste formulas to the rest of the cells
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks Ben, I was having a hard time with this 1![]()
Try this:
You'll of course have to adapt row / column references to suit your final solution, but you should get the principle.![]()
Please Login or Register to view this content.
![]()
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
On your example, if you delete P14 to Y19 and run this macro:
It will return the correct results that you typed in - maybe this helps?![]()
Please Login or Register to view this content.
@FDibbins:
you're very welcome. but it looks like OP is looking for VBA code.
@system0:
if you're very sure you want VBA codes, you could post in the Excel Programming / VBA / Macros section in the future. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks