Search results

Hi Bharath, Yes we do face this problem in Pivot tables when we use Formula's in our data. A better way is to show them as "-" which means No Data. Please follow below instructions in case you need "-" instead of Zero's. Select your Entire Pivot Table. Press Ctrl + 1 - This will openup...

Hi, You can use COnditional Formating for above. New Rule Format only cells that contain Cell Value - Between - first number refrence - second number refrence. Format the colour as per your requirement. Press OK.

In case you are interested, You can also download it as an Excel file. http://wwwhome.ewi.utwente.nl/~trieschn/excel/function_lookup.xls (From the same link)

You can use macro to do this. I use this in one of my current sheet. Just to help you with the code. If (Range.Value) = "(Criteria)" Then Sheets("Sheetname").Shapes("Shapename").Select Selection.ShapeRange.Fill.ForeColor.RGB = 2764187

Might be this will help you. In Microsoft Excel the names of functions depend on the language of the installed version of MS-Office. Here's a link containing the Excel function names in 16 languages. http://wwwhome.ewi.utwente.nl/~trieschn/excel/excel.html

That's awesome.

If possiblem, also all the columns that would be updated/changed in Pivot should calculate as Average. (When we insert any column any Pivot table - Value, it shows Count.)

Hi, I have a pivot table with huge data in it. Beside Pivot Table I have inserted a Combo box dropdown having number 1 till 5. Now I need if I select 1 in this dropdown, in pivot table - Values - 10 Column should be inserted in Pivot table. if 2 then 7 different Columns & rest should be...

Lets wait for HUI cause if there's a solution HUI will definately know how to do it. If you are in a hurry, you can use two pivot tables to reflect the data as you need by hiding the row labels in 2nd pivot.

Above given formula works best. I tried to use only IF & Weekday - that too worked. =IF(WEEKDAY(F20-16,2)=6,(F20-16)-1,IF(WEEKDAY(F20-16,2)=7,(F20-16)-2,F20-16))

You will just have to use Calculated Field in the pivot table. CLick on your pivot table - In Ribbon Goto Formulas - Calculated Field In Name Type - Total In Formula you just have to add all the months. From Fields dropdown below slect January then enter + then Feb then + ... till Dec...

For Percentages, you can show Subtotal as Average - it might make sense. I am still wondering if there is a possibility to remove subtotal from some columns.

If it is linked to excel, it will be updated through excel only or else what is the use in linking it with excel & manually updating it in powerpoint. I dont think both ways are possible or even required. Still lets see if some1 has a solution.

Data which you have provided confusing. Can you please attach an excel of the same.

Oops.. you are correct. I should have tried your formula as array. Thanks for letting us know.

Put both fields in Row labels. Double click on the first header row, in Subtotals select None. Still if its not working, please share screenshot of your file.

^^^ You can use Concatenate formula for this. Or you can use "&".

x=15 =+IF(U5>=x,2,IF(AND(U5>0,U5<15),1,0))

Hi, You can manullay enter these aging days in some particular cell & refrence that cell in your IF formula. Please help with some example data in this post itself so that I can help you with formula.

Use below Array Formula - =SUM(IF(ISNUMBER(FIND(D8,A1:A15)),1,0)) Remember, enter this as an array formula (press ctrl-shift-enter rather than just pressing enter.) I have also worked out a simple formula, but its not worth...

Yup, put both items in Values area, & they will come in same row.

Hui, I think he is having more than 2 sheets, (So on So on..) I think a simple macro code would work here for unlimited sheets.

Copy the range from excel (however you like) Go to powerpoint slide. On the Home Ribbon, select the arrow under PASTE and choose PASTE SPECIAL. Select HTML Format, press OK. You can now edit the table in powerpoint itself. (This works smoothly on my PC, only I have to arrange the font...

Thanks HUI.

hUI, Have send you the sheet. Please upload & share.