Results 1 to 12 of 12

Locate-select records with both ColA & ColC filled

Threaded View

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    Crete
    MS-Off Ver
    Excel 2003
    Posts
    13

    Locate-select records with both ColA & ColC filled

    Hello forum,

    I am currently editing a road name index worksheet to use as a reference index in a book. This table has 3 columns as follows..

    road name 1 neighbourhood name 1 page number1
    road name 2 neighbourhood name 2 page number2
    - - page number3
    ----
    this has 6ooo records in it....I am trying to locate-select the records in Column C that do not have a Column A cell filled in (or more easily has both colA & colB filled cell). I am doing that in order to continue with a sort by column A to have the final look of the table.

    would a sort by column A do the trick I am looking for in order to discard unwanted data afterwards?would the sort be affected by empty cells in Column B?

    regards
    Last edited by aiolosply; 07-17-2012 at 05:20 AM.

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