tag:blogger.com,1999:blog-1198012538392840871.comments2023-05-18T19:29:15.116+05:30Excel HelpRitesh Patelhttp://www.blogger.com/profile/10586198329665085740noreply@blogger.comBlogger24125tag:blogger.com,1999:blog-1198012538392840871.post-6984270732980443432021-10-13T16:23:51.710+05:302021-10-13T16:23:51.710+05:30This was great! ThanksThis was great! ThanksAnonymoushttps://www.blogger.com/profile/04010322632160623389noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-20667696889340148102019-12-21T18:25:43.293+05:302019-12-21T18:25:43.293+05:30Very useful. Thank you so much. But I want to make...Very useful. Thank you so much. But I want to make the pyramid from a pivot. And I am not sure how to add the negative value column to the pivot. Could you please that as well?Rhttps://www.blogger.com/profile/13048232781900698053noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-32763651660762785872019-04-24T14:40:02.207+05:302019-04-24T14:40:02.207+05:30Wonderful explanation. Wonderful explanation. Ranjithhttps://www.blogger.com/profile/07464351242891373982noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-74697911177472137632015-11-26T02:25:31.462+05:302015-11-26T02:25:31.462+05:30If you want an out-of-the-box solution and you hav...If you want an out-of-the-box solution and you have Excel 2013, you can now benefit from the various apps that are published in the MS Office Store. For example, the yellohcharts app has build in zooming function and timeline navigation. If you go to www.yellohcharts.com, you can see the demo video.<br /><br />If you go to https://store.office.com/appshome.aspx and search for the Yellohcharts app, you can try it for free...hope this helps.<br />Anonymoushttps://www.blogger.com/profile/15895110406715797933noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-50845248426170245692015-10-03T19:40:39.813+05:302015-10-03T19:40:39.813+05:30this was super helpful !!
Thank you so much this was super helpful !!<br />Thank you so much Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-79466812923935114732014-05-20T09:09:05.117+05:302014-05-20T09:09:05.117+05:30Applying custom grouping to Pivot tables in C#<a href="http://www.kettic.com/winforms_ui/csharp_guide/pivotgrid_group_report.shtml" rel="nofollow">Applying custom grouping to Pivot tables in C#</a>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-55178731823795197902013-11-26T04:47:56.689+05:302013-11-26T04:47:56.689+05:30You should add more data series for creating chart...You should add more data series for creating charts with crossing axis and subtotals. But have a simle way. Look at this http://fincontrollex.com/?page=products&lang=en<br />Anonymoushttps://www.blogger.com/profile/08366085327623052275noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-39694563340001727282013-10-22T08:27:58.554+05:302013-10-22T08:27:58.554+05:30This one shows clearly steps involved in enabling ...This one shows clearly steps involved in enabling developer tab. Good one. <br />If you want a video tutorial for this just follow the link<br />https://www.youtube.com/watch?v=bRcb9WNhKC0<br />I hope this will help you gusy. Anonymoushttps://www.blogger.com/profile/04429534489460860002noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-89047959056368948902013-09-30T01:09:15.100+05:302013-09-30T01:09:15.100+05:30Or you can use the 'Stacked Bar' option an...Or you can use the 'Stacked Bar' option and enter the left set of data as negative values.Anonymoushttps://www.blogger.com/profile/01747260087185622830noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-61590213520132073752013-08-15T18:26:15.304+05:302013-08-15T18:26:15.304+05:30This graph can be used for representing the number...This graph can be used for representing the numbers (actuals, targeted etc) . Drawing inferences like how many to hire and fire etc completely depends on the business scenario.Ritesh Patelhttps://www.blogger.com/profile/10586198329665085740noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-45211497810046620972013-08-13T15:02:11.305+05:302013-08-13T15:02:11.305+05:30Very useful...
Any help on drawing inferences from...Very useful...<br />Any help on drawing inferences from it? Say how many to hire n how many to fire :-)ABChttps://www.blogger.com/profile/04514555063379690171noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-25689738464449005092013-08-11T19:21:05.575+05:302013-08-11T19:21:05.575+05:30Kindly refer to http://excelhelpbyriteshpatel.blog...Kindly refer to <a href="http://excelhelpbyriteshpatel.blogspot.in/2013/08/creating-advanced-waterfall-graph.html" rel="nofollow">http://excelhelpbyriteshpatel.blogspot.in/2013/08/creating-advanced-waterfall-graph.html</a> for steps on creating waterfall graph where running total moves from positive to negative or vise-versaRitesh Patelhttps://www.blogger.com/profile/10586198329665085740noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-53237777206323445402013-07-30T16:34:19.848+05:302013-07-30T16:34:19.848+05:30Very good, but how do you do this when the adjustm...Very good, but how do you do this when the adjustment moves running total from positive to negative?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-10769633529936019182013-06-12T21:51:49.727+05:302013-06-12T21:51:49.727+05:30Hello,
Thanks for the feedback.
To answer your qu...Hello,<br />Thanks for the feedback.<br /><br />To answer your questions:<br /><br />1. This formula is designed assuming that data is stored in specific way i.e. is in years.months format only and it may not give desired result if it is applied on other formats like date. The purpose is to give fair idea about how we can use various inbuilt functions like MOD, FIND, MID etc. to perform such operations. If you wish to use it in some other conditions, you will have to tweak this formula or design new formula based on the requirement using similar logic. Can you please elaborate it further, like how is the data stored, expected outcome etc.; I can help you with the formula.<br /><br />2.Assuming your value is in A2 cell…<br /> a) Formula to get the length of decimal part only: =LEN(A2)-FIND(".",A2)<br /> b) Formula to get value of decimal part only: =VALUE(RIGHT(A2,LEN(A2)-FIND(".",A2)))<br /><br />Hope this help…<br /><br />Thanks!<br />Ritesh Patelhttps://www.blogger.com/profile/10586198329665085740noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-19707206307185007282013-06-11T18:23:21.174+05:302013-06-11T18:23:21.174+05:30Hi Ritesh,
It's really very great and helpful ...Hi Ritesh,<br />It's really very great and helpful post that you created here. I was looking for this since long but could not crack it. It saved my lot of manuall efforts which i used to put-in to achieve this. Thnx a ton BOSS!!!<br /><br />It would be nice if you just address below issues as well in this - <br /><br />1) It works well when you have two dates basically, but, goes for toss when using for a single date value only.<br /><br />e.g. If I have to caluculate the Years and Months (in the same format which you have considered) with only one date, say, 23-Dec-04, it does not work well.<br /><br /><br />2)Also it wold be helpful if you could sahre the formula to fetch out the lencgth and value of decimal part only.<br /><br />Again many many thnx for such a nice blog. :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-43740116799325728412013-05-15T16:48:46.942+05:302013-05-15T16:48:46.942+05:30Thanks!Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-41579848469197467082012-07-08T14:55:51.229+05:302012-07-08T14:55:51.229+05:30Hi,
Need more clarity on your question.
1. I am ...Hi, <br />Need more clarity on your question. <br />1. I am not able to differentiate the input and the expected output. Can you please explain it in more details.<br />2. Also, please let me know where you want the output/results, do you need it in an Excel file?Ritesh Patelhttps://www.blogger.com/profile/10586198329665085740noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-20051977975553574752012-07-07T22:21:11.659+05:302012-07-07T22:21:11.659+05:30Hi I have an assignment for which I need to use VB...Hi I have an assignment for which I need to use VBA <br />I have a text file, a sample of which I am showing below.<br /><br />Tom_Cruise|21|1998|07041971|New_avenue|A1|0<br />Michael_Corleone|15|2001|04071981|Old_street|B2|0<br />Serena_Tucker|25|2004|<br />05081985|National_park|C3|1<br />James_Frank|15|2005|01021983|Reynold's_street|<br />D10|0<br /><br />I need to write a code so that the file will appear as indicated below<br /><br />Tom_Cruise|21|1998|07041971|New_avenue|A1|0<br />Michael_Corleone|15|2001|04071981|Old_street|B2|0<br />Serena_Tucker|25|2004|05081985|National_park|C3|1<br />James_Frank|15|2005|01021983|Reynold's_street|D10|0<br /><br />Please help me write a code. I understand I need to use the line input function. I am new to VBA and I am finding it a little difficult to write a code.<br /><br />Is there any function I need to use that could make this process faster. <br /><br />Thanking everyone for the help.<br />Looking forward to a prompt responseCalculushttps://www.blogger.com/profile/14688438422809294969noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-88545395964859327892011-11-27T14:23:30.104+05:302011-11-27T14:23:30.104+05:30Thank you for your help Ritesh... Learnt a new met...Thank you for your help Ritesh... Learnt a new method from you. I am expaning this method to 15x15 matrix. It really worked out... :)<br /><br />Thank you once again!Punithhttps://www.blogger.com/profile/06174348743537514255noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-397434409597761802011-11-27T00:23:17.007+05:302011-11-27T00:23:17.007+05:30Hi Punith,
What I can figure out from your questi...Hi Punith,<br /><br />What I can figure out from your question is that you are facing problem with cell referencing. To achieve this you can use Indirect formula.<br /><br />1. Please add a column at the end (i.e. column F) in your data, which we will use for Indirect formula. You can hide this column after applying formula. <br />2. Type 2 in cell F2. <br />3. Type formula in F3 as “=F2”. We are just taking same value as F2.<br />4. Now go to cell F6 and type formula as “=F2+1”<br />5. In Cell F7, copy the formula of cell F3. Which will become “=F6”<br />6. Now apply indirect formula in cell D2 as “=INDIRECT("A" & F2) +2” - Indirect function converts text into range, we are passing static value “A” and concatenating it with value of cell F2 (i.e. 2). So it becomes “A2”<br />7. Similarly apply formula in cell E2 as “=INDIRECT("A" & F2) +3”.<br />8. Now you can copy cells D2 and E2 and paste it in cells D3, E3 and in D6, E6, D7 & E7 respectively. <br />9. To further expand this table, you can select cells with formulas in 4 rows together, i.e. from D6:F7 and keep pasting it in the table below. (values in Column F will get incremented by 1 after every 4 rows, which will ensure that cell referencing of formulas in column D & E will be incremented only after 4 rows)<br /><br />That’s it. You can manipulate formula of column F to get the proper referencing. <br />Hope this helps. Thanks !Ritesh Patelhttps://www.blogger.com/profile/10586198329665085740noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-35089470636646441402011-11-26T23:32:30.291+05:302011-11-26T23:32:30.291+05:30Sir i am experiencing problem in incremental copyi...Sir i am experiencing problem in incremental copying in excel.<br />Problem: Suppose i have these values<br />a1:angle<br />a2:1<br />a3:2<br />a4:3<br />a5:4<br /><br />i am creating a matrix of 2x2 for variation of each angles. <br />Suppose this is 2x2 matrix for variation of 1degree angle.<br /><br />d2=$a2+2 e2=$a2+3<br />d3=$a2+2 e3=$a2+3<br /><br />Now i want to copy d2:e3 and paste below the first 2x2 matrix i.e., starting from cell d6 to get the variation of 2degree angle. <br />So, i want in this order below which i am not able to get.<br /><br />d6=$a3+2 e6=$a3+3<br />d7=$a3+2 e7=$a3+3<br /><br />Please help on this....This is a basis for a larger matrix formulation.Punithhttps://www.blogger.com/profile/06174348743537514255noreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-46716376651354712282011-09-08T10:36:54.181+05:302011-09-08T10:36:54.181+05:30It is very easy to understand, I could make it eas...It is very easy to understand, I could make it easilyAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-83907980909725680782011-09-07T15:41:54.705+05:302011-09-07T15:41:54.705+05:30its nicely represented & easy to understandits nicely represented & easy to understandAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1198012538392840871.post-37280929774980501492011-09-07T15:24:34.366+05:302011-09-07T15:24:34.366+05:30Thanks!!! this really helped meThanks!!! this really helped meAnonymousnoreply@blogger.com