by Ilker | Sep 7, 2018 | Excel Tips & Tricks
VLOOKUP, HLOOKUP or their predecessor LOOKUP are Excel’s most famous lookup functions. However, these functions can search a value only in a single dimension, meaning that you can’t search horizontally and vertically. Unfortunately, there are no formulas...
by Ilker | Sep 6, 2018 | Excel Tips & Tricks
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...
by Ilker | Aug 30, 2018 | Excel Tips & Tricks
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...
by Ilker | Aug 30, 2018 | Uncategorized
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...
by Ilker | Aug 30, 2018 | Excel Tips & Tricks
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(...
by Ilker | Jul 27, 2018 | Excel Tips & Tricks
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...
by Ilker | Jul 27, 2018 | Excel Tips & Tricks
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...
by Ilker | Jul 27, 2018 | Excel Tips & Tricks
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, ...
by Ilker | Jul 27, 2018 | Excel Tips & Tricks
It’s often a good idea to highlight empty cells in a data set to help easily identify the outliers. Here, you can find out how to highlight empty cells dynamically using Conditional Formatting. Steps Begin by selecting the data range B3:H10 Open the Conditional...