Conditional Ranking in Excel using SUMPRODUCT Function [RANKIF]

First of all, just do this for me, open your Excel workbook and try to type RANKIF. You will be wondered that there is no function in Excel for conditional ranking.Yes, there is no one.Now, just think this way, have you ever faced a situation where you have to rank values by using some specific […]

Weighted Average in Excel

The weighted mean is similar to an ordinary arithmetic mean (the most common type of average), except that instead of each of the data points contributing equally to the final average, some data points contribute more than others.

Excel 3D Reference for Cells

We all want to save our time.And, by using 3D Reference in Excel you can save your a lot of time.It’s is like three-dimensional chart or image which has more than one phase. A normal range is all about a group of cells from a single worksheet.For Example, in =SUM(Sheet1!A1:A10), “A1:A10” is a group of cells […]

How to Automatically Update a Pivot Table Range in Excel

If you use pivot tables in your work frequently, I am sure you face the problem to update its source data range manually.Every time when you add new data in the source sheet you need to update the source range for the pivot table before you refresh your pivot table.Now, just imagine if you add […]

How to Create a Pivot Table from Multiple Worksheets

With a pivot table, you summarize your data within a few seconds. You can create reports, analyze data, and easily share with others.That’s the beauty of pivot tables.But here is a twist:Normally when you create a pivot table you can select source data from a single table in a worksheet as Excel doesn’t allow you […]