Results 1 to 12 of 12

Advance Filtering question?

Threaded View

tlapointe1970 Advance Filtering question? 02-23-2012, 10:49 AM
NBVC Re: Advance Filtering... 02-23-2012, 10:55 AM
NBVC Re: Advance Filtering... 02-23-2012, 11:01 AM
tlapointe1970 Re: Advance Filtering... 02-23-2012, 11:24 AM
NBVC Re: Advance Filtering... 02-23-2012, 11:35 AM
OnErrorGoto0 Re: Advance Filtering... 02-23-2012, 11:40 AM
NBVC Re: Advance Filtering... 02-23-2012, 11:46 AM
OnErrorGoto0 Re: Advance Filtering... 02-23-2012, 11:49 AM
NBVC Re: Advance Filtering... 02-23-2012, 11:50 AM
tlapointe1970 Re: Advance Filtering... 02-23-2012, 12:25 PM
NBVC Re: Advance Filtering... 02-23-2012, 12:37 PM
OnErrorGoto0 Re: Advance Filtering... 02-23-2012, 12:37 PM
  1. #1
    Registered User
    Join Date
    04-15-2011
    Location
    gray
    MS-Off Ver
    excel 2007
    Posts
    52

    Advance Filtering question?

    I am attempting to use the advanced filtering options in Excel 2010. I am not having any luck despite following the instructions I found online. Please see attached spreadsheet. I am trying to filter out any row that contain all Zeros.

    I must be setting the filter range incorrect or something because nothing happens when I apply the filter. Could someone review and let me know what I am doing wrong?

    These are the steps I followed:

    when I click on advance filter, I receive a warning about my header row, which I tell it to use as labels and not as numbers.
    my list range is set to $C$95:$N$269
    my criteria range is set to $C$7:$N$270
    'filter in place'

    Thank you for your help. Terri
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1