Ron, I am sorry I did not give all the data. There is a column header when I
was referring to row numbers I was referring to the data I showed, but the
column header is unit.

"Ron Coderre" wrote:

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