Results 1 to 5 of 5

Filtering unwanted cells

Threaded View

gjonm Filtering unwanted cells 09-29-2009, 10:11 AM
Cheeky Charlie Re: Filtering unwanted cells 09-29-2009, 10:34 AM
gjonm Re: Filtering unwanted cells 09-29-2009, 11:10 AM
gjonm Re: Filtering unwanted cells 09-30-2009, 09:41 AM
Cheeky Charlie Re: Filtering unwanted cells 09-30-2009, 10:00 AM
  1. #1
    Registered User
    Join Date
    09-29-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    3

    Exclamation Filtering unwanted cells

    I'm trying to filter out unwanted data from a spreadsheet.

    I have two columns, (A) contains a series of numbers and this is the search criteria. Column (B) contains the data.

    Example:

    A
    7887765
    4344555
    2233455
    8386375
    3647364
    3847387

    B
    7875895
    3847387
    8386375
    5345344
    3465356
    9887645
    5767655
    8386375
    3847387

    8386375 & 3847387 appears in column A and twice in B


    I want Excel to filter out any unique numbers in column B which don't appear in column A.

    Is this possible?

    I'm using Excel 2007.

    Thanks

    Gav
    Last edited by gjonm; 09-29-2009 at 10:14 AM. Reason: Format

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