+ Reply to Thread
Results 1 to 4 of 4

Attendance Filter Function Not Displaying results correctly

  1. #1
    Registered User
    Join Date
    10-11-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    58

    Attendance Filter Function Not Displaying results correctly

    Hi,

    Previously i had some help on here to enable a filter function using drop down menus on my companies attendance tracker. (worked perfectly)
    Since then i have revised the tracker and found new ways to make the workbook neater,cleaner and smaller, while also retaining its functionality except one the previously working filters.

    The filter works perfectly for the shifts only.
    If i select either Position or Department filter options all i get is the same employee displayed regardless.

    Any chance someone can take a look at my attached file please?

    If you can explain where i have gone wrong as well that would be great so i know for future reference.

    Thanks
    Mark
    Attached Files Attached Files

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Attendance Filter Function Not Displaying results correctly

    Are you working from the Detailed View sheet when filtering? If so, I don't see dropdowns for Position or Department.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    10-11-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    58

    Re: Attendance Filter Function Not Displaying results correctly

    missed that bit out filters are only applied to the overview sheet

    Thanks Mark

    *Edit*

    I have sorted the filtering issue, i had the position and department reference's in the formula the wrong way round
    Last edited by MarkPr; 11-30-2017 at 04:01 AM.

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Attendance Filter Function Not Displaying results correctly

    Glad you were able to figure it out.

+ 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] VLOOKUP function not displaying results
    By B24Mike in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2015, 01:09 PM
  2. Excel 2010 Filter a value then displaying results
    By Lensmeister in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-29-2015, 06:48 AM
  3. [SOLVED] IF Function and displaying results as words?
    By BoxerPower555 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-19-2014, 12:19 AM
  4. Get results from filter function
    By rich47 in forum Excel General
    Replies: 2
    Last Post: 06-08-2011, 06:37 PM
  5. [SOLVED] Match function and displaying results
    By Dan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2006, 04:55 PM
  6. [SOLVED] multiple results when using filter function
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  7. Replies: 3
    Last Post: 08-30-2005, 02:05 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