Search results

Hi, Change your last line of the code to reflect as: Range("E7").Value = Range("E6").Value + 1 Regards, Prasad DN

Hi, Pls also include the expected output manually, so that it will be more clear. Regards, prasad DN

Sorry, I was thinking you were taking about Textbox from developer tool. Your file shows its a shape object. Yes, I see the challenge. Regards, Prasad DN PS: Could not find any workaround.

Hi, I inserted an Textbox (activex control) an excel file and saved and shared, (although none opened at the same time). I was able to use the textbox as normal without any issue or blocked. Not sure what is your question/challenge. Regards, Prasad DN

Hi Xor LX, amazing technique, I have gone through your link. Now, I have one question to you. How do you even think of such solutions? And connecting Financial solution oriented formula NPV to such situation!! Brilliant!! Regards, Prasad DN

Hi, I like the Deepak's solution but was not able to understand them quite well. My bad :(. At the same time, for your question, you can extend D's solution with & and repeat the formula, with substituing A2 with same formula again...

In continuation to what Wudixin says, when you open two excel files as two separate instances, generally, some of the functions/formula do not work as expected in 2007 or greater versions. As suggested by Wudixin, you need to open the referenced workbook from the existing workbook from open...

Hi Narayan, Yes, I can see the list of posts, I have liked, but as mentioned in my post, I would like to know why I liked that post :) ? And with mere title of thread it is quite difficult! so thats why I thought if some #tags can be added ... Regards, Prasad DN

NP narayan. Thank you

Hi Chandoo, As forum is also a product from chandoo, i thougth of placing my request here. Well, in the forums I see a lot of good questions being asked and some very interesting solutions for different members. Is it possible to make one additional feature in the forum webpage to, Option...

Hope this will solve: =INDEX(A1:A4,SUMPRODUCT((B2:D4=C8)*ROW(B2:D4))) See the attached file. Regards, Prasad DN

Hi Narayan, how would the formula be different for a situation where you have two or more names with same total? Regards, Prasad

Hi, You already have the option to type the text/number in the filter drop down. You can use wildcard search with it. If my understanding is not correct provide some more details. You may be also interested to see the below link: http://chandoo.org/wp/2011/10/10/how-to-use-advanced-filters/...

It is not clear what is your requirement! Can you come up with different data set and result. Regards, Prasad DN

hi, Can you provide more details of your questions, I am afraid its not clear. Regards, prasad dN

For some reason we (atleast me), tend to forget the usage of this beautiful "aggregate" functionality, may be it will get acquainted sooner and become frequently used formula. Thank you for this solution! Regards, Prasad DN

Hi Febausa, I have used on helper column to concatenate all your columns, and then used countif(). Attached is the file. Regards, Prasad DN

Hi, At textbox can have only values, and no formulaes. Again, if you want the textbox to display statement/text with combination of values from different sources, then Yes, it is possible with VBA. Regards, Prasad DN

:-) good catch!! And as coincidence the 2nd point was exactly on 31st. Thank you Luke! Prasad

Hi Luke, Thank you looking into this issue. As you suggested, I did try dates as data points, and the output was not exactly what I wanted. In your file as well, I see x axis having two oct-14, Nov-14 and Jan-15 data points, while I need to show the graph with only 6 points, i mean the...

Sorry, posted before I could complete... Original file name: copy of conditionalLine2 and my file name: graph... line Regards, Prasad DN

Hi, I was checking how to plot different color of same series chart like % of actuals above SLA% and below SLA%. I did find a very good solution from Andy Pope's site, that it can be done either with formula or with VBA. I am able to get the result replicated in my book, except for one...

Hi Rahul, I am sure you have gone thru links shared by Hui for both type of solution. I thought of sharing one more method, say you have all email IDs in col A, step1. type ";" in col B for all the rows where you hav data in Col A. step2. Copy both the columns together and paste in...

Hi Jason, Try this: ComboBox1.AddItem cell.Value & " " & cell.Offset(0, 1).Value & " " & cell.Offset(0, 2).Value Regards, PrasaD DN

Hi Gaurav, share your code and the sample file of inputs so that one can understand how the sub folders are placed in inputsheet whether columnwise or rowwise and accordingly suggest the solution. Regards, Prasad DN