+ Reply to Thread
Results 1 to 2 of 2

adavanced filtering

  1. #1
    Registered User
    Join Date
    12-28-2009
    Location
    Sydney,Australia
    MS-Off Ver
    Excel 2003
    Posts
    31

    adavanced filtering

    Hi there,

    I have two columns , student and mark . I want to select the students who have a mark of greater than 70. Is this the right way to do it ?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ron2k_1's Avatar
    Join Date
    09-30-2009
    Location
    Not the USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    606

    Re: adavanced filtering

    1. Select A1:B1
    2. Go to Data:Filter:AutoFilter
    3. Select the arrow on B1: Custom Filter
    4. Select "Greater than or equal to"
    5. Type 70 on the corresponding slot.

    Does that help?
    Ron
    Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad

    Kindly

    [1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
    [2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
    [3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated

+ Reply to Thread

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