Consulting

Results 1 to 7 of 7

Thread: With PivotTable: Count consecutive days that meet a criteria

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-12-2021, 05:32 AM #1
    AaliiyahN82
    AaliiyahN82 is offline
    VBAX Regular
    Joined
    Apr 2020
    Posts
    12
    Location

    Exclamation With PivotTable: Count consecutive days that meet a criteria

    Hello, so I need to display a list of names that will meet 3 criteria: Absent for 2 days, 3 days, and over 3 days. And the days should be consecutive. Also I need to use a pivot table.

    I have never used a calculated pivot table. Please help. Attached a sample workbook.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

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