Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2004
    Location
    Portsmouth, Hampshire, England
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot vs Filter - strange results

    The attached workbook has a single column table on Sheet1 and a Pivot Table based on it on Sheet4.

    If you look at the Pivot Table it has 2 rows for AL but click on the Filter arrow for the single column table on Sheet1 and there is only one AL listed.

    The difference is that the Pivot Table honours the space following some of the ALs, whilst the Filter does not.

    Beware...
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Yes I find it odd that autofilter ignores leading and trailing spaces, especially when it can be problematic with pivots, lookups, etc.

    I don't know of any option to turn off the feature in autofilter to make it exact. In addition to leading and trailing spaces, the autofilter also ignores the difference between a number and text that looks like a number, which can also lead to issues...

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •