Hello everyone.
I have a excel sheet and i use a "choose" formula but just its possible choose from 13 columns and i need 52 because its the number of weeks from the year, its possible make working in all weeks of the year but in a diferent way.
Livro1.xls
If someone can help me i would say Tanks You
Last edited by nunocabete; 12-01-2012 at 05:39 PM.
In this forum you can attach files to your post, and many contributors are reluctant to load a file from another website. Please read the FAQ for details of how to attach a file.
Hope this helps.
Pete
you may want to use index/match instead of choose if you have that many choises. as suggested, please upload the sample workbook here.
To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
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
Already make that.
Tanks
In C6: =INDEX(19:19, MATCH("SW" & TEXT($B$4, "00"),$17:$17, 1))&""
In D6: =INDEX(19:19, MATCH("SW" & TEXT($B$4, "00"),$17:$17, 1)+1)&""
Copy those two cells down.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I try but not working!
Really?
Put the formulas in as instructed and then post that workbook so we can see what you did.
in C6 use this, copied down...
=INDEX($A$17:$CZ$28,ROW(A1)+2,MATCH(IF(LEN(B4)=1,"Sw0","Sw")&$B$4,$17:$17,0))
in D6, use this, copied down...
=INDEX($A$17:$CZ$28,ROW(B1)+2,MATCH(IF(LEN(C4)=1,"Sw0","Sw")&$B$4,$17:$17,0)+1)
Already work the problem its that i have to replace all ( , ) to ( ; ). Now appear another problem the chart that apear from the values not apear its blanck. The legend its ok but the bar on chart no. Any answer to this problem????
Last edited by nunocabete; 12-02-2012 at 05:59 PM.
Sounds like a completely separate topic for the non-VBA forum. Post your new query in a new thread with supporting documents.
If that takes care of your original query, please select Thread Tools from the menu above and mark this thread as solved.
With the second formula works. Dont know whay but works.
Will study and see if i understand.
Tanks.
Close Post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks