+ Reply to Thread
Results 1 to 4 of 4

How to filter certain data....

  1. 10-03-2019, 01:13 AM #1
    Abhilash1503
    Abhilash1503 is offline
    Registered User
    Join Date
    09-11-2019
    Location
    India
    MS-Off Ver
    2007
    Posts
    7

    How to filter certain data....

    Hi Team,

    I have a data as mentioned below

    excl.PNG

    is there any way to sort out the particular data as mentioned in the image....

    Well i just need the data mentioned in the right column...

    Thanks in advance
    Reply With QuoteRegister To Reply
  2. 10-03-2019, 01:20 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,969

    Re: How to filter certain data....

    Filter based on the last column not showing blanks?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 10-03-2019, 01:26 AM #3
    Abhilash1503
    Abhilash1503 is offline
    Registered User
    Join Date
    09-11-2019
    Location
    India
    MS-Off Ver
    2007
    Posts
    7

    Re: How to filter certain data....

    No bro....From the left column i just need those data in the right side column
    Last edited by AliGW; 10-04-2019 at 01:13 AM. Reason: Please don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  4. 10-04-2019, 01:06 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,969

    Re: How to filter certain data....

    You want to just show what is in the right column - so filter on that.

    If that is not what you wanted, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    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. [SOLVED] Filter data by Columns (a,b,c etc) and mark the top 3 items for each filter.
    By margetc in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-15-2018, 04:18 AM
  2. VBA Advanced Filter - Two Filters Without Deleting Bottom Filter Data In Same Column Range
    By hysterical.useless in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2017, 02:54 PM
  3. [SOLVED] Find Count of filter, Advanced filter Data
    By linok in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 01-06-2015, 04:41 AM
  4. Filter data type mismatch? Filter column of numbers from criteria on 2nd sheet w/ wildcard
    By sdl2 in forum Excel General
    Replies: 1
    Last Post: 12-12-2014, 06:46 AM
  5. Using filter with list stored in a column and process data for each filter selection
    By shailew in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2014, 10:55 AM
  6. Filter data and edit with a search istead of the filter button
    By dhamit in forum Excel General
    Replies: 2
    Last Post: 10-07-2013, 04:57 AM
  7. Second Advanced Filter does not work based on the data generated from the filter
    By mucc1928 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2011, 02:42 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