+ Reply to Thread
Results 1 to 6 of 6

Advanced Filter gives not the expected result

Hybrid View

  1. 02-05-2021, 05:16 AM #1
    Harry_1101
    Harry_1101 is offline
    Registered User
    Join Date
    03-17-2020
    Location
    Winterswijk
    MS-Off Ver
    2013
    Posts
    7

    Advanced Filter gives not the expected result

    Hi there,

    In my data I have simular names in the columns like fkt and fktc.
    The filter cannot filter the fktc from the fkt input....
    How can this be changed without changing the data?

    rgData.AdvancedFilter xlFilterInPlace, rgCriteria, True, if stated False it makes no difference.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-05-2021, 06:12 AM #2
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,689

    Re: Advanced Filter gives not the expected result

    To select only fkt I have changed criteria. Pl see file.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  3. 02-05-2021, 07:37 AM #3
    Harry_1101
    Harry_1101 is offline
    Registered User
    Join Date
    03-17-2020
    Location
    Winterswijk
    MS-Off Ver
    2013
    Posts
    7

    Re: Advanced Filter gives not the expected result

    Hi, where is the file?
    Reply With QuoteRegister To Reply
  4. 02-05-2021, 06:20 AM #4
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,681

    Re: Advanced Filter gives not the expected result

    Quote Originally Posted by Harry_1101 View Post
    The filter cannot filter the fktc from the fkt input....
    How can this be changed without changing the data?
    Use a wild card in criteria like

    fkt*
    Reply With QuoteRegister To Reply
  5. 02-05-2021, 07:45 AM #5
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,689

    Re: Advanced Filter gives not the expected result

    Sorry. Here is the file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 02-05-2021, 09:59 AM #6
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,343

    Re: Advanced Filter gives not the expected result

    Format C2 as text, then enter =fkt as the criterion.
    Everyone who confuses correlation and causation ends up dead.
    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] using advanced filter, getting result that is not accurate (also error)
    By dmcgov in forum Excel General
    Replies: 5
    Last Post: 04-10-2020, 10:45 AM
  2. NOT expected result in macro
    By LoganTRK in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-05-2019, 11:16 AM
  3. [SOLVED] Advanced Filter using AND logic does not return expected values for non-numeric values
    By NeedToKnowMore in forum Excel General
    Replies: 6
    Last Post: 08-13-2018, 08:26 AM
  4. not getting expected result
    By Patcheen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2018, 09:51 AM
  5. advanced filter - button to re apply advanced filter across multiple sheets
    By motmac87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2013, 11:16 PM
  6. Advanced formula - Return result & Show Cell Reference of result
    By Irv in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-05-2006, 10:40 PM
  7. advanced filter a range:Advanced Filter function
    By Il Principe in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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