Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Filter question Michael Raphael Excel Worksheet Functions 3 August 11th 06 04:28 PM
Filter question Bg Excel Worksheet Functions 7 July 4th 06 08:45 PM
Filter Question bodhisatvaofboogie Excel Discussion (Misc queries) 1 June 20th 06 04:23 PM
a filter question [email protected] Excel Discussion (Misc queries) 3 May 16th 06 08:59 PM
filter question Nigel Excel Discussion (Misc queries) 2 May 6th 05 12:59 AM


All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"