+ Reply to Thread
Results 1 to 6 of 6

Pivot table filter fron two range

  1. #1
    Forum Contributor
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2019
    Posts
    101

    Post Pivot table filter fron two range

    Hi,
    Can anyboby help me out.I need to filter start & finish dates from two column with same criteria.
    Please find attached sheet,I need starting & finishing item in a range from 1 Jan 18 to 15 Jan 18.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Pivot table filter fron two range

    I don't understand your request. Can't you just autofilter.

    Hi,

    This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

    Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Pivot table filter fron two range

    Based upon data shown, what should the end result look like. Not sure I understand your needs.
    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

  4. #4
    Forum Contributor
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2019
    Posts
    101

    Re: Pivot table filter fron two range

    In a simple way I need to sort items falling in range 1 Jan 18 to 15 Jan 18.
    Some Item start date will fall in this range & some item finish dates.
    When filter start date I dont want to bother finish date & vice versa.

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Pivot table filter fron two range

    Please provide a sample of your expected output as requested by both Richard and me. Your new explanation is no clearer in visualizing what you want than your first explanation.

  6. #6
    Forum Contributor
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2019
    Posts
    101

    Re: Pivot table filter fron two range

    Data
    Item Start Finish
    A 1-Jan-18 15-Jan-18
    B 8-Jan-18 17-Jan-18
    C 15-Feb-18 28-Feb-18
    D 10-Jan-18 15-Feb-18
    E 1-Jan-18 30-Jan-18
    F 15-Dec-17 10-Jan-18


    Expected Result
    A 1-Jan-18 15-Jan-18
    B 8-Jan-18 17-Jan-18
    D 10-Jan-18 15-Feb-18
    E 1-Jan-18 30-Jan-18
    F 15-Dec-17 10-Jan-18

+ Reply to 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 Pivot table based on Range
    By allstarrunner in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-10-2020, 07:37 AM
  2. Can you filter a pivot table in VBA with Date Range
    By Justair07 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2016, 03:38 PM
  3. Set Pivot table Filter to a date range using VBA
    By BlueDan2015 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-05-2015, 07:58 AM
  4. Pivot Table Filter Range
    By Lumini in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2014, 11:49 AM
  5. Replies: 4
    Last Post: 10-10-2012, 03:38 PM
  6. [SOLVED] Filter a pivot table by list in a range
    By MikeWard100 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2012, 07:31 PM
  7. Replies: 5
    Last Post: 01-06-2012, 04:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1