You know that Pivot Table is one the most important tools to analyze data. And, Conditional Formatting is useful to deliver a strong message to the user along with data. Ahead of this post, you will learn about how you can combine these two awesome tools. You will learn to apply conditional formatting in pivot table.
Today in this post, I will show you how to group dates in a pivot table in excel. Before using this technique I used to create columns for year, quarter and months in my source data. But, this technique of grouping dates in pivot table will allow you to combine dates in the form of months, quarters, year.
Yesterday, when one of my subscribers ask me for help about her problem which she was facing. All she needed was to combine SUMPRODUCT IF Functions to get data from a table. She was trying hard to create a formula but unfortunately she was unable to sort out her problem. While solving her problem I have learned a new thing to create SUMPRODUCT IF Statement.