Grouping Items in an Other Category

If you're modifying a list of items and wanted to categorize them in a few category names and have everything else in some general Other bucket it's fairly easy to do with the SWITCH function. Better to do this than using nested IF functions, which can get pretty long. Check out the video to see how it works.