Search results

Hi, I was working on an exercise on dashboards on this website which uses a pivot table. I am stuck on why my pivot table is not working. This is a simple pivot with an additional field name from the field list that is filtered but is shown in the pivot. It should take into account the filter...

I am using excel 2010 working with a pivot table. I have first and last names and their respective dates of birth together with their sales. two sales people have the same first and last name and different dates of birth and I want to see them on separate lines but when I put the last name...

Hi, I have a pivot table with my source data being salespersonID, SalesDate and ProductID as the rows and count ProductID as the value. I have added another field to the source data with following formula =IF(COUNTIFS($A$2:A2,A2)=1,1,0) showing the distinct SalespersonID and added this field to...

Hi, I have a main list of 200 entries. The headings are ID, Date, value. The ID and Date will be duplicated at various times, however the value will be different. E.g. ID…..Date……Value 101…01/01/13…89 101…01/01/13…78 102…02/03/13…66 102…02/03/13…50 I was given a smaller unique list of...

Hi, I have a column of salaries with the data starting in A2 to A200 I need to sum the salaries less than $300 and greater than $500. I can do a SUM in an Array and get the correct answer but I want to do a SUMIFS statement, if possible? I have tried the following but I get zero as the result...

Hi, I am an intermediate user of Excel 2010 but this is a really basic question for which I cannot find any information about . I have never used the Custom properties tab found within “Info, Properties, Advanced Properties. Can someone please explain why you would use the dropdown fields of...