Search results

Hi, I tried by first creating the pivot table of the data, and then with any of the cell in PT being selected, I clicked on insert chart and made multiple charts with different chart types. Now, whenever I change the PT filter the graphs for all the charts are changing. Is this what you...

Hi Sheri, I know you are looking for solution without helper column. Attached file is with helper column used, but gets you the desired output. In case you may be interested. Regards, Prasad DN

Hi.. etecsmedia I guess you want to upload a file in dropdox location and provide us the link so that we can access the file here. And with that you want to post your question. if so, why not just upload a file directly in this site itself? the link Bobhc shared has the steps to upload a...

Hi Umesh, Assumption: You will not have any different project codes worked by same person on same day. Looks like we have exact solution to your requirement in the recent article with ultimate vlookup. Here is the link: http://chandoo.org/wp/2014/10/28/multi-condition-vlookup/ formula for...

Hi, Try this: File >> Options >> Excel Options Pop up appears. click Customize Ribbon >> select all the tabs that you need or simply select reset ribbon Regards, Prasad DN

Hi, see the file if it helps for you. Regards, Prasad DN

Hi AsparAgus , in your code, 1 is setting the both criteria1 and criteria2 to be applied on same field(column). Range("B6:B2000", "D6:D2000").AutoFilter 1, Criteria1:=">" & stDate, _ Operator:=xlAnd, Criteria2:="<" & stDate1 As you have two different columns, you need to put your code...

Hi, Did you try the following code line: ActiveWorkbook.BreakLink Name:="Book3", Type:=xlExcelLinks Instead of "Book3" specify your required file name. Regards, Prasad DN

Hi, I ran your macro and it is working fine, what and where is it erroring for you? Regards, Prasad DN

Hi Shrivallabha, Request you to explain the various values for "type:" parameter of application.inputbox() pls. Regards, Prasad DN

Hi you can try sum function as CSE formula with array of parameters as below: h3={SUM(--(B3:F3={2,3,5,7,11}))} and you can do the same for the other cells as well. Note: Do not enter "{}" manually, it will be applied on pressing Cntr+Shift+Enter keys. At the same time, you need to...

Hi, would it help you if you keep the cursor selecting B4 Cell and freeze panes based on current selection option? or are you looking for something different? Regards, Prasad DN

Arif, I guess you want formula want to copy from alternate cells, right? to answer you need to share where you want this data to be pasted. Regards, Prasad DN

Hi Dr.Demento.. Welcome to this forum! This can be done but not be in the same PT. You will continue to keep the existing PT. Plus you will have to create your a separate report with expected name with columns like abv and full name, and other necessary columns that you have in PT. Once...

Hi Max, The explanation provided and the example does not seem to be quite done with one line command. this would need two loops of VBA Code, but to write the same, can you upload with some real data that you are going to use. As it vba code may need to take turn in loops based on contents...

Hi, How does this mmult work? pls explain if you have time. I have seen number of times this function/formula being used particulary in this site itself. also, Interestingly, if the formula is entered in one cell (even as CSE) the result is different compared to select the range G20:G29, why...

Hi Mike, Check this file if it is what you were looking. Regards, Prasad DN

hi, Pls post some more examples in file and upload with expected out put like you did in the original file. Regards, Prasad DN

Hi igorsusa, I understand you can only change the values in yellow. At the same time you may have to think that values in "K" which is currently negative is derived from B1- SL or B2-SL, etc, it is a formula, but your file is not have the formula. When you were instructed not to change...

Hi, Use the below formatting in your formula: concatenate($D77,TEXT(O$7,"dd-mmm-yy")) Regards, Prasad DN

Hi, See the file This can be done with sumproduct() formula along with Mid() and left() formulas. Regards, Prasad DN

Hi, You may also use Pivot Table to get the same. Regards, Prasad DN

Hi, Here is some basic invoice i downloaded from internet and made little changes. I have added one sheet with all the details I need for invoice. you need to enter the cust ID in cust ID cell like 1 or 2 or whatever you have created customer ids. The rest of the information about that...

Hi, Try this =TEXT(A1,"00.0000") Regards, Prasad DN

@Somendra Misra, I did not go thru the output. :(