Thread: Filter Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 698
Default Filter Question

Filtering requires a heading cell on each column.
In your situation, since the range begins in Row_1, the filter declares the
Row_1 values to be those headings. Consequently, the first 3125 isn't part of
the data range; it's the column heading.

To correct your problem, insert a row at the top and put appropriate
headings in it.


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"gboll" wrote:

I have some data that represents what is below in a column of my spreadsheet:

3125
3125 3120
3130 3125
3125
3115 3125

I have a filter on my sheet and when I do a custom filter on that column and
use contains 3125, I do not get the results in row 1 and 4 above, but just
the other ones that have 3125 with another number (rows 2,3, & 5). Am I
doing something wrong, or does anyone know why that is happening?

Thanks in advance