Hello Guru's,
I have been playing around with some data and can't seem to get it the way I want it. I have played around with Pivot tables and grouping but I can't seem to figure out how to accomplish what I need in Excel. To better explain I have attached some test data of what I am trying to accomplish. Thanks in advance for your help!
Last edited by abaumgartner; 08-02-2014 at 06:19 AM.
Please change the title of your question, according to the forum rules.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I can't seem to find what to change the title? I try to edit but doesn't allow me to change the title. I am sure its something easy but its late
HI,
Check the updated file with formula in sheet 2.
Punnam
That is perfect, Thank you. Would you mind explaining how you did that? It looks like some complicated Formulas.
Last edited by abaumgartner; 08-02-2014 at 06:05 AM. Reason: forgot to thank poster
hi abaumgartner.
As per the for the forum rules it is necessary for you to change the tile as as instructed by oeldere which helps us to understand & Respond immediately
I will explain in details first do the necessary as per the post 2 of oeldere .
Give a name "Find Unique & calculate the Total of Work order ".
Punnam
Punnam
Hi, Punnam
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.
If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc
@abaumgartner:
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
Ciao,
Holger
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Found it and changed the title. Thanks.
Last edited by abaumgartner; 08-02-2014 at 06:49 AM.
If it is easier rather than explaining the formulas, Would someone be kind enough to help me make a template I could paste the data into and it would generate what I need? I know basic formulas but I am no expert. I have attached What the template would be.
Again Thanks for all the help!
@ HaHoBe,
Note 1) This happened due delay in uploading process
2) Post 2-3 & 4 are happened simultaneously
3) the moment i have seen oeldere post, i instructed the user to do necessary changes as requested by Oeldere . u can find the same in "Post 6
Punnam
Test Template.xlsx
i used pivottable, please check attached sheet this may help you.
thanks
Hi,
I have updated as template
Disadvantage
1) It takes more time to generate the WO column.
Punnam
2 options:
1) With an pivot table.
See the attached file (2nd sheet).
Or
2) With VBA to hide and unhide the columns.
Just push the buttons.
hi check the file how to achive it using pivot table
Perfect. Thank you for all the help guys!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks