+ Reply to Thread
Results 1 to 4 of 4

Need Help Filtering Certain Values

  1. 09-10-2021, 07:28 PM #1
    FortunaFavetFortibus
    FortunaFavetFortibus is offline
    Registered User
    Join Date
    09-10-2021
    Location
    Houston
    MS-Off Ver
    2016
    Posts
    2

    Need Help Filtering Certain Values

    Hello Guys!

    I hope everyone is doing well. I need a help on how to filter just certain types of values. I have lots of data that I need to filter to find out missed punches. Below is example of data column:

    Actual Check-Ins
    01:00 AM - 07:45 PM
    01:00 PM
    01:00 PM - 06:40 PM
    01:01 PM - 01:03 PM, 05:16 PM - 08:00 PM
    01:05 PM - 08:59 PM, 09:02 PM

    Ideally, I would like to filter to show only missed punches, which in these case those are:
    01:00 PM
    01:05 PM - 08:59 PM, 09:02 PM

    Please be aware there is more than 5k rows and each has unique number. The structure is the same though.

    Thank you!
    Reply With QuoteRegister To Reply
  2. 09-10-2021, 10:13 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Need Help Filtering Certain Values

    What's a "missed punch"?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  3. 09-10-2021, 10:20 PM #3
    FortunaFavetFortibus
    FortunaFavetFortibus is offline
    Registered User
    Join Date
    09-10-2021
    Location
    Houston
    MS-Off Ver
    2016
    Posts
    2

    Re: Need Help Filtering Certain Values

    It is when someone Clocks In to work but does not Clock Out from work. For example in below record they just clocked in but did not clock out (missed punch):

    01:00 AM

    Below they clocked in and clocked out (no missed punch)

    01:05 PM - 8:59 PM

    Here they clocked in at 01:01 pm and clocked out at 01:03 pm. Then clocked in again at 05:16 pm and clocked out at 08:00 pm (no missed punches):

    01:01 PM - 01:03 PM, 05:16 PM - 08:00 PM

    And here they clocked in at 01:05 pm and clocked out at 08:59 pm (no missed punch). But they forgot to clock out after they clocked in at 09:02 pm (missed punch):
    01:05 PM - 08:59 PM, 09:02 PM
    Last edited by FortunaFavetFortibus; 09-10-2021 at 10:22 PM.
    Reply With QuoteRegister To Reply
  4. 09-11-2021, 07:04 AM #4
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,188

    Re: Need Help Filtering Certain Values

    There are instructions at the top of the page explaining how to attach your sample workbook.
    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. Excel Filtering Issue (filtering out value "0", other values get filtered too)
    By samcoarse in forum Excel General
    Replies: 4
    Last Post: 09-03-2017, 06:32 AM
  2. [SOLVED] Filtering with Cell Values using VBA
    By nKife in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-27-2016, 10:16 PM
  3. Filtering on multiple values
    By excelboo in forum Excel General
    Replies: 2
    Last Post: 02-29-2016, 08:00 AM
  4. Filtering values
    By MikeNZ in forum Excel General
    Replies: 4
    Last Post: 04-02-2013, 02:35 AM
  5. [SOLVED] Filtering Values
    By tomudell in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-19-2012, 12:31 PM
  6. Combining Values in rows and keeping unique values (adv. filtering?)
    By nguyeda in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2011, 01:48 PM
  7. Filtering linked values
    By kerbear80 in forum Excel General
    Replies: 14
    Last Post: 01-14-2010, 05:24 PM

Tags for this Thread

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