How to merge cells in excel without losing data

How to merge cells in excel without losing data

by | Sep 6, 2018

Excel will give you a warning message telling that you will lose the data, when you try to merge cells using the Merge & Center feature. In this article, we’re going to show you how to merge cells in Excel without losing your data.   Steps Begin by...
A Guide to Custom Sorting in Excel

A Guide to Custom Sorting in Excel

by | Sep 5, 2018

Excel is widely recognized for its powerful data sorting features, seamlessly organizing data in ascending or descending order, whether alphabetically or numerically. However, there are scenarios where the standard A-to-Z or 0-to-9 sorting methods may not suffice....
How to create a year-by-year average calculator

How to create a year-by-year average calculator

by | Aug 30, 2018

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 count cells in Excel by year

How to count cells in Excel by year

by | Aug 30, 2018

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 start date

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

by | Jul 27, 2018

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...
Count unique values Excel

Count unique values Excel

by | Jul 18, 2018

This article shows how to count unique values Excel formulas SUMPRODUCT and COUNTIF. The SUMPRODUCT function can handle arrays without actually using array formulas, and this allows evaluating the formulas in each cell of an array. Syntax =SUMPRODUCT( 1 / COUNTIF(...
How to get last match

How to get last match

by | Jul 17, 2018

This article shows how to get last match by using MAX, MIN, IF and ROW functions. Excel’s array formula ability to evaluate formula for each cells in an array is key factor in this case.Syntax{ =MAX( IF( data = search value, ROW( data ) – MIN( ROW( data )...
How to find closest match

How to find closest match

by | Jul 17, 2018

This article shows How to find closest match by using INDEX, MATCH, ABS and MIN functions. Excel’s array formula ability to evaluate formula for each cells in an array is key factor in this case. Syntax { =INDEX( return array,      MATCH(         MIN(ABS( search...