The program your data comes from may be adding extra spaces or hidden characters
to the data.

Filtering in that case would be next to impossible.

Download Chip Pearson's CellView Add-in, install it and see what is in those
cells that won't filter.

http://www.cpearson.com/excel/CellView.aspx


Gord Dibben MS Excel MVP

On Thu, 31 Jan 2008 10:58:00 -0800, jamesr
wrote:

working on a excel worksheet that my data comes from one program onto a excel
spreadsheet. Tried everything and still no go.. trying to filter my data down
to one customer and their data only on my spread sheet