Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

Now, let’s use Excel’s RIGHT () function to extract the last two characters from each value. To do so, enter = RIGHT([@Department],2) into H3 and copy to the remaining cells.