Results 1 to 10 of 19

Thread: Copy to Summarise data based on 2 criteria: User ID and gaps in continuous day segments for same user

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 12-09-2022, 08:18 AM #10
    ayazgreat
    ayazgreat is offline
    Member ayazgreat's Avatar
    Join Date
    Mar 2012
    Posts
    86
    Rep Power
    13
    Alan,

    Please find attached updated file for your question that why I have more than 1 result for 12345.
    Actually if you see result sheet I am calculating total days and total working days between start date and end date and all result is based on each number and different dates of each number.
    Attached Files Attached Files
    Last edited by ayazgreat; 12-09-2022 at 08:21 AM.
    Somthing is better than nothing
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Select column based on user input
    By Wall31 in forum Excel Help
    Replies: 4
    Last Post: 06-21-2020, 06:18 AM
  2. Force user to use date format dd/mm/yyyy on User Form
    By Flupsie in forum Excel Help
    Replies: 5
    Last Post: 06-13-2014, 08:37 PM
  3. Copy paste data based on criteria
    By analyst in forum Excel Help
    Replies: 7
    Last Post: 01-13-2014, 12:46 PM
  4. Copy data from 1 excel workbook to another based on certain criteria
    By Matt_M in forum Excel Help
    Replies: 2
    Last Post: 09-18-2013, 12:30 AM
  5. Insert Or Delete Columns Based On User Input
    By HDMI in forum Excel Help
    Replies: 4
    Last Post: 06-21-2013, 03:00 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