Search results

Hi, I have a pivot table with country name on one column and corresponding count of products on another column. I have plotted pie chart for the same which gets updated with changes each time i refresh the pivot table.I have declared country names as a dynamic range list in another sheet(...

Hi, I have two tables one in sheet 1(table 1-Controlling table) and another in sheet 2( table 2). Kindly see the attached sheet: https://www.dropbox.com/s/wzvljbi7mhzt2nn/table.xls The Count column in table 2 has sumproduct formula eg...

Hi , I am working on a enquiry tracking sheet which has tabs Jan to Dec, Yearly enquiry list, Q1-Q4 graphs and Yearly graph . I have included a sample copy of the original sheet( which has more columns and data, but is confidential). A sample has been uploaded at the below link for more...

Hi , I am working on a enquiry tracking sheet which has tabs Jan to Dec, Yearly enquiry list, Q1-Q4 graphs and Yearly graph . I have included a sample copy of the original sheet( which has more columns and data, but is confidential). A sample has been uploaded at the below link for more...

There are two columns A and B. When the user manually enters country name in cells under column A, two scenarios arise: 1. If country name entered is " India", the adjacent column should display a drop down list for user to choose from. (List entries North , South, East, West) 2. if country...