When filtering in Excel you will be shown all the entries in a field. Unfortunately, if there are hundreds of unique items this can mean a lot scrolling to select the correct item to filter by.
Monthly Archives: March 2014
Handling Text in Calculation Cells in Excel
If you need to do mathematical calculations on cells that may contain numbers or text, then you can use the IFERROR function to ignore the text.