Select Page

## How to count by week number

To count by week number is a bit different than by month. Instead of finding the start and end dates of the date range, we focus on exact week number using the WEEKNUM function. Syntax =COUNTIFS( range of week number helper column, current week number) Steps Add a...

## How to sum by week number

To sum by week number is a bit different than How to sum by month. Instead of finding start and end dates of date range, we focus on exact week number by using WEEKNUM function. Syntax =SUMIFS( range of values to sum, range of week number helper column, current week)...

## How to convert Excel columns to rows – Unpivoting

This article explains how to convert Excel columns to rows, also knows us unpivoting, using VLOOKUP formula. Unpivoting is the opposite of pivoting data (see Pivot Tables) by distributing values from a single column to multiple columns while keeping unique values in...

## How to create conditional Excel drop down lists

It’s often a good idea to use drop down lists or combo boxes to limit user errors make the data more standardized. However, sometimes we want our drop downs to populate under some conditions. Here, you can find out how to create conditional Excel drop down using Data...

## How to highlight values based on item lists

It’s often a good idea to highlight the duplicate values in a data set to help easily identify the outliers. Let us show you how to highlight values based on item lists using Conditional Formatting. Syntax =COUNTIF( absolute reference of list of values, relative...

## How to replace character in Excel by position

This article shows how to replace character in Excel by position using REPLACE function. If you are looking to replace a specific character please refer to article How to replace a character. Syntax =REPLACE( text, start position of replacement, number of characters...

## How to replace characters in Excel

Excel’s built in find and replace feature is fairly useful in most cases. But this can get tedious if you’re working with a large workbook or want to set this up dynamically. In this article we’re going to show you how to replace characters in Excel...

## Grouping Dates in Pivot Table

Excel already has functions like the SUMIF and the SUMIFS for summing data by groups. However, they won’t work when have date-time values combined. In this article we will cover grouping dates in Pivot Table. Steps Select a cell in your data Click Pivot Table...

## How to sum by date in Excel without time

Excel already has functions like the SUMIF and the SUMIFS for summing data by groups. However; they can’t work if you have date-time values combined. This article shows How to sum by date in Excel without time using SUMPRODUCT and INT functions. Syntax...