Search results

Hi bilboy, I did find something thats working, it looks very ugly formula though :( =IF(IFERROR(IF(VLOOKUP(LEFT(B9,1),_S1,1,0)=LEFT(B9,1),VLOOKUP(MID(B9,2,LEN(B9))/1,_p1,1,0),IF(VLOOKUP(LEFT(B9,1),_s2,1,0)=LEFT(B9,1),VLOOKUP(MID(B9,2,LEN(B9))/1,_p2,1,0),NA())),"")="","",B9) Take a look at...

@Deepak and @Nebu, The suggestion would make the PT not to show Field Headers, i.e. Category for row and drop down of columns. I hope thats what OP wanted. @OP, If you are looking only to remove the column heading dropdown and to retain Category label then.. Just hide the entire row...

Hi, At the original post, if the question is a alternate function for numbervalue()? then instead of: IFERROR(_xlfn.NUMBERVALUE(RIGHT(M2,3)),_xlfn.NUMBERVALUE(RIGHT(M2,2))) The revised formula will be =IF(ISNUMBER(RIGHT(M9,3)/1),RIGHT(M9,3),RIGHT(M9,2)) And for example ...

Hi, In your file, with existing formulas in B5, add the below formula in B6 and then drag down. =B5&","&A6 The last row will have all in one cell. Regards, Prasad DN

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