Search results

Hi Gaurang, Hope this helps you. =SUMIFS(YTD!M:M,YTD!M:M,"<50",YTD!F:F,D7)/COUNTIFS(YTD!M:M,"<50",YTD!F:F,D7)

Hi Shankar, when you refresh the pivot table the column will get added to the pivot table field list, now you have to select USPS from the pivot table field list, then only the column & the relevant data will get updated in the pivot table. If still the problem persist, please attached the excel.

Hi, Click on pivot table<Options<Change data Source & include the new columns added in the data source, hope this solves your problem.

Did you try the pivot charts.

Hi, Please find attached the excel. Hope this is what you were looking for.

Hi Venkat, How do you arrive at the rank. If rate is 100-200 the rank is 1, from 201-300 the rank is 2. Please do let me know if my understanding is correct.

Hi Jawahar, If want to know which chart to choose. please go through this article http://chandoo.org/wp/2010/04/19/chart-selection-process/ If you want dynamic charts, please upload the example excel

Thanks, for the code. It is not working. If you have the time can you please check it I have already attached the worksheet. Thanking you in advance for this help.

You can lock other column apart from the current month, where you want the users to enter the data.

Hi, To answer your 2 levels of data validation. Try the custom option in settings in data validation. Here type out the formula which satisfies all your condition. This should work.

Hi, Go to data validation. In setting>Date. In Data select the between option & enter the start & end date. By setting this condition only dates with the start date & end date can be entered by the user.

Hui Thanks, Actually it will be sent to students to asses their word knowledge. so the cells will be blank. Please find attached the excel.

Hi All, Cells for working are c,d,e,f. If there is YES in any cell{c,d,e,f}, then other cells should automatically display as NO I Tried the if or condition, it worked fines for cell c, when the formula is entered in d, it says circular error. The formula in c3...

Hi, Sorry your question is not clear. What do you want. Do you need a template to maintain the details for 3 stores. Do you want to consolidate stocks in all the 3 stores & want to know what is the stock on hand from all the stores.

Hi, Please post the excel, how did you get 0 & 1 in col 3 & 4 for A X.

Refer to this link in chandoo website http://chandoo.org/wp/2010/02/19/excel-consolidate-data/

Hi, http://chandoo.org/wp/2009/01/08/timestamps-excel-formula-help/

Hi, Try the 3-D Pie option in the pie charts. This helps you to drag the Pie pieces separately.

Hi, =IF(FIND(zipcode ,the cell that contains the group of zipcode,1),the cell that contains the employee name,0). The find function matches the zipcode from the group of zipcodes & returns the name of the employee.

Hi, Find attached the workbook, hope this help you. This is a combination of 2 charts.

Hi, For this you need to go to Pivot table options & tick the check box against for error values how:, leave the value box bank. Now the error will disappear in your pivot. Filer on non-blank in pivot & you will get the required details

Hi, Save the workbook as macro enabled workbook. Insert this code in sheet1. If you want some other color, please change the ColorIndex number Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveCell.Font.Bold = True ActiveCell.Interior.ColorIndex = 7 End Sub

Hi, The updated file is attached, please use the sumifs formula & use the dates in all rows.

No tricks, I just applied the pivot. I guess you have changed something in the heading, as you heading is not generated by the pivot that was the reason for heading disappearing when you filter.

Hi, Refer sheet 2 in the attached file. Duplicate values are not shown because the parameters you have selected in the pivot are the same. If you want to see the duplicate value just insert the Quantity row. The same is added by me in sheet 2 in the attached file. The last column heading is...