Closed Thread
Results 1 to 3 of 3

Excel 2007 : Filtering

Hybrid View

  1. #1
    Registered User
    Join Date
    10-29-2010
    Location
    lancashire, england
    MS-Off Ver
    Excel 2003
    Posts
    14

    Filtering

    I would be so happy if you could help me with filtering.
    I have 250 rows in each column A - M and yes each has a set of six digits separated by a ,
    I have starting at A1 to N250 data, all numeric containing 6 numbers (i.e. 1,2,3,4,5,6 - 25,96,113,78,5914,27) and with these I wish to filter them as follows:
    any with 4,5 or 6 odd or even numbers
    any with more than two consecutive numbers
    any with more than two within a range of 10

    If needed I can put them all on 13 sheets and with help have one set of six numbers per row as I do not know how to swap them over. also as they all relate to different aspects I could not place them all in A column so would need to keep column's seperate.

    Thank you in advance for your help.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: In need of help with filtering.

    Please do not double -post. It is not necessary.

    You posted here as well: Help with Excel filtering
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Registered User
    Join Date
    10-29-2010
    Location
    lancashire, england
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: In need of help with filtering.

    Quote Originally Posted by Palmetto View Post
    Please do not double -post. It is not necessary.

    You posted here as well: Help with Excel filtering
    sorry but I thought this would be a better place to get an answer as I am using excel 2007

Closed 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