+ Reply to Thread
Results 1 to 3 of 3

Extract Records without Blank

  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.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Extract Records without Blank

    Hello,

    create a helper column and count the values in the three DUNS columns. Assuming that your data starts in column A

    =count(B2:D2)

    Copy down.

    Use the Autofilter to show only rows that have a value of than 3 in that helper column.

    cheers,

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

    Re: Extract Records without Blank

    Awesome, thank you very much

+ 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