Results 1 to 3 of 3

Extract Records without Blank

Threaded View

  1. #1
    Registered User
    Join Date
    05-20-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    26

    Extract Records without Blank

    Hello Experts,

    I have Another query in which i just want to extract records which doesn't have blanks in particular cells for example.

    Account Name..........DUNS..............ULT_DUNS................GLOBAL_DUNS

    XYZ..........................11444...............253565658..................9874654
    AMAZON.................. <> ................ <> ...................5452151
    Google.....................1542154............15451543..................... <>
    ABC......................... <> ............. 89654132....................545454


    Now i want it should return row no 2,3,4 because one of the column's cell is blank. apologize if i am not able to explain correctly.

    The result should look like this

    Account Name..........DUNS..............ULT_DUNS................GLOBAL_DUNS

    AMAZON.................. <> ................ <> ...................5452151
    Google.....................1542154............15451543..................... <>
    ABC......................... <> ............. 89654132....................545454


    Any help is appreciated

    thanks
    Last edited by ischopra; 06-20-2011 at 07:34 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