Ranks in a Pivot Table

 By using a pivot table, you can summarize your data in an understandable manner. And, that summary can help you to analyze data on category wise, product wise, month wise, etc. One of the common practices for analyzing data is by ranking them. Ranking categories and products can help you to compare them with each other. The […]

Generate Random Letters in Excel

Ever faced a situation where you need to generate random letters? Yes, sometimes we need to generate random letters. We have functions like RAND and RANBETWEEN to generate random numbers but we don’t have any particular function to generate letters. But today, I will share with you an amazing formula trick to generate random letters in […]

Conditional Ranking in Excel using SUMPRODUCT Function [RANKIF]

RANKIF: Conditional Ranking in Excel using SUMPRODUCT 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 […]

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 […]