Extracting Data by Cell Values in Excel

 Let’s say you have a large workbook of names and addresses and you need to find only those folks listed with area codes of 207 and 613. You could sort the data by area code and copy and paste after each section – or you could use the FILTER function.

Here’s how:

ExtData-1 Select the entire range of data you want to filter for a specific value(s)
SortFilter Click the SORT&FILTER icon on the right side of the Ribbon
Filter Select “Filter
dropdown The selected range should now have drop-down arrows at the head of each column
SelectFilter Click the down-arrow on the column that you want to Filter on.Uncheck the “Select All” box.Check the values you want to filter for.Click OK
NumberFilters Note: If you click on “Number Filters“, a list of options will display. The default is “Equals“.If you wish to use another strategy, select it here.
Outcome The outcome of this action is shown to the left
Clear To clear the filter, click on the down-arrow again and select “Clear Filter…”The range will return to normal
text If you had chosen to sort the text column instead, you would have been presented with text options as shown to the left.

Trackbacks

  1. [...] Extracting Data by Cell Values  If you need to extract a set of records from a large workbook, you can use the SORT&FILTER [...]