+ Reply to Thread
Results 1 to 4 of 4

Need help on how to filter this

  1. 02-09-2020, 09:50 PM #1
    supadupawil
    supadupawil is offline
    Registered User
    Join Date
    02-09-2020
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    2

    Unhappy Need help on how to filter this

    Hi, this is my first time posting here so I am not sure if this is the right section.

    But i attached a sample of a document that i do not know on how to filter it or tabulate it so i can understand it better.

    I tried Text to Column but maybe I am not doing it right.

    Please help,anyone..

    Thank you so much!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-09-2020, 10:57 PM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Need help on how to filter this

    Hi,

    Does this look fine? It looks as some headers might be here and there, but overall looks fine to me.

    I basically concatenated each row from Columns A through G and then used TextToColumns using ; as delimiter
    Attached Files Attached Files
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
  3. 02-10-2020, 12:41 AM #3
    supadupawil
    supadupawil is offline
    Registered User
    Join Date
    02-09-2020
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    2

    Re: Need help on how to filter this

    Yes, this is awesome!

    I just don't know how to sort it like that.

    Can you teach me how to do that concatenate, what do i need to input.I am not familiar using concatenate yet.

    Thank you so much!
    Reply With QuoteRegister To Reply
  4. 02-10-2020, 05:13 AM #4
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Need help on how to filter this

    Hi,

    Basically use the Concatenate function and click on each cell from the 1st Data Row > PasteSpecial Values and put that on a different sheet > Then use TextToColumns
    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. Inserting filter into pivot table via macro errors if filter doesn't exist.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2018, 10:24 AM
  2. Need to create report using Advanced Filter, multiple filter criteria and Hidden Sheets.
    By MaintWork in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2017, 02:39 AM
  3. 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
  4. Filter common criteria from 2 columns & filter large of filtered values from 3rd column
    By shreeja178 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-16-2014, 08:42 AM
  5. Need to filter a report filter based on the previous filter
    By elliotencore in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-28-2014, 07:44 AM
  6. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  7. Filter several pivot tables by one programmed date range filter in Excel 2003
    By olewka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2011, 11:49 AM

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