+ Reply to Thread
Results 1 to 11 of 11

Filter data with blanks

  1. 04-22-2014, 08:39 AM #1
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Filter data with blanks

    hello
    i m using below code to filter my data
    Please Login or Register  to view this content.
    i want filter data with blanks cells

    thanx
    Reply With QuoteRegister To Reply
  2. 04-22-2014, 08:48 AM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,716

    Re: Filter data with blanks

    Change your criteria to:

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 04-22-2014, 09:23 AM #3
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: Filter data with blanks

    MOD

    NOT working
    Reply With QuoteRegister To Reply
  4. 04-22-2014, 09:48 AM #4
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,716

    Re: Filter data with blanks

    What does not working mean? What results are you getting? What were you expecting? Mind reading is not my specialty.


    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Reply With QuoteRegister To Reply
  5. 04-22-2014, 10:04 AM #5
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: Filter data with blanks

    i m using filter on range "C10:C500"

    C10:C17 Has data

    i filter the "AHSAAN G"
    I want also filter blank row C18:C500

    workbook attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 04-22-2014, 10:11 AM #6
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,716

    Re: Filter data with blanks

    I apologize that I will not be able to help. Your file crashed my computer and I cannot open the file. Hopefully, someone else will have better success. Good Luck.
    Reply With QuoteRegister To Reply
  7. 04-22-2014, 11:02 AM #7
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Filter data with blanks

    Ditto, Post#6.
    Reply With QuoteRegister To Reply
  8. 04-22-2014, 11:42 AM #8
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: Filter data with blanks

    Hey JOHN

    what is Ditto, Post#6
    Reply With QuoteRegister To Reply
  9. 04-22-2014, 11:45 AM #9
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Filter data with blanks

    Quote Originally Posted by haroon2015 View Post
    Hey JOHN

    what is Ditto, Post#6
    Your file crashed my computer and I cannot open the file.
    Reply With QuoteRegister To Reply
  10. 04-22-2014, 11:49 AM #10
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: Filter data with blanks

    JOHN Sorry for that

    but that file which one i upload is just about 567kb,,, its a sample of my workbook, and i m using 5mb version, never my pc crashed due to opening my file,,, then why yours pc is crashing can't understand

    BTW
    Will u plz check this thread
    http://www.excelforum.com/excel-prog...ml#post3670323

    thanx
    Reply With QuoteRegister To Reply
  11. 04-22-2014, 11:53 AM #11
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: Filter data with blanks

    Thread is closed due to crashing pc,,,,,

    I apologize

    to Mod alansidman And JOHN
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Filter non-blanks from selected columns
    By rajivbravo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2012, 07:23 AM
  2. Filter non-blanks and replace cells
    By imdl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2011, 02:37 PM
  3. Filter column by non-blanks
    By ABSTRAKTUS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2011, 04:00 PM
  4. Filter Formula & Include Blanks
    By henrythompson in forum Excel General
    Replies: 1
    Last Post: 03-25-2008, 10:05 AM
  5. Advanced Filter (Criteria + Blanks)
    By SamuelT in forum Excel General
    Replies: 4
    Last Post: 07-05-2006, 12:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1