Filter Question
 

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

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

Filter Question
 

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

Filter Question
 

In the autofilter, I believe "contains" works on text, not numbers.
Evidently those two values are numeric. If you prepend an apostrophe (') to
one of the 3125 values, it should then display when filtered.


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

XL2002, WinXP


"gboll" wrote:

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

Filter Question
 

Yes, thanks. Now I have to figure out an easy way to make it work.

"Ron Coderre" wrote:

In the autofilter, I believe "contains" works on text, not numbers.
Evidently those two values are numeric. If you prepend an apostrophe (') to
one of the 3125 values, it should then display when filtered.


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

XL2002, WinXP


"gboll" wrote:

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

Filter Question
 

Maybe something like this:

Select the range of cells

Then...from the Excel main menu:
<data<text to columns
Check: Delimited...........Click [Next]
UNcheck all checkboxes ....Click [Next]

(OR....
Select: Fixed Width....Click [Next]
Remove all text breaks....Click [Next])

Set the column format to: Text
Click [Finish]

Now try the autofilter

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

XL2002, WinXP


"gboll" wrote:

Yes, thanks. Now I have to figure out an easy way to make it work.

"Ron Coderre" wrote:

In the autofilter, I believe "contains" works on text, not numbers.
Evidently those two values are numeric. If you prepend an apostrophe (') to
one of the 3125 values, it should then display when filtered.


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

XL2002, WinXP


"gboll" wrote:

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

Filter Question
 

Maybe you could insert a new column and use a formula like:

=""&a2
(where column A contains this info)

Then filter on that.

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

--

Dave Peterson