Select Page

How to sort in Excel in a custom order

You can sort data easily from A to Z, or 0 to 9, in ascending or descending order. But what if you want to sort data in a different way, say starting with “Low”, then “Medium”, and “High”? In this article, we’re going to show...

How to copy a formula in Excel between workbooks without links using a text editor

You may have noticed that Excel generates links between workbooks, when you copy and paste a formula from one to the other. These links between worksheets call the original workbook for the formula you need in the present workbook. To get rid of them, you need to...

How to copy a formula in Excel between workbooks without links using Find & Replace

You may have noticed that Excel generates links between workbooks, when you copy and paste a formula from one to the other. These links between worksheets call the original workbook for the formula you need in the present workbook. To get rid of them, you need to...

How to create a year-by-year average calculator

Although the AVERAGEIF and AVERAGEIFS function can sum values by a given condition, they won’t work if you want to use the output in other functions. In this article, we’re going to show you how to create a year-by-year average calculator with help of the...

How to create a year-by-year summation calculator

Although the AVERAGEIF and AVERAGEIFS function can sum values by a given condition, they won’t work if you want to use the output in other functions. In this article, we’re going to show you how to create a year-by-year summation calculator with help of...

How to count cells in Excel by year

Although the COUNTIF and COUNTIFS functions can count values by a given condition, they won’t work if you want to use the output in other functions. In this article, we’re going to show you how to count cells in Excel by year. Syntax =SUMPRODUCT( N( YEAR(...

What week of the year is it and how to get its end date

Although Excel has a function to get week number of a date, WEEKNUM; there isn’t any to make reverse calculation. This method will help you answer the question – what week of the year is it, and give you the end date of each week. Syntax =MIN(DATE(current...

What week of the year is it and how to get its start date

Although Excel has a function to get week number of a date, WEEKNUM; there isn’t any to make reverse calculation. This method will help you answer the question – what week of the year is it, and give you the start date of each week. Syntax...

How to find unique values Excel

Managing and organizing data doesn’t have to be a daily routine. You can automated tasks like finding the outliers in your data. In this article, we’re going to show you how to find unique values Excel. Syntax { =IFERROR(   INDEX( data,     MATCH( 0,    ...