+ Reply to Thread
Results 1 to 6 of 6

Staff Assessment

  1. #1
    Registered User
    Join Date
    11-01-2012
    Location
    Nigeria
    MS-Off Ver
    Excel 2007
    Posts
    15

    Staff Assessment

    Am trying to create a sheet that will help staff assess othe colleagues. If am John the drop down menu shouldn't show my name. Secondly, whenever any name is selected, the Id. column (in yellow) should return the corresponding person's (in blue) id selected. Thank you.
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,684

    Re: Staff Assessment

    May be this..

    In E4 Cell
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Drag it down...


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Staff Assessment

    Quote Originally Posted by bolajidopemu View Post
    If am John the drop down menu shouldn't show my name
    there are several possibilities of getting the windows username which then can be compared with the list to remove it, see here: example.xlsm

    See columns G:K and find the username that represents the user, in the corresponding column heading you'll find the way it has been generated
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,684

    Re: Staff Assessment

    @ tehneXus,

    =IFNA() seems to be a new arrival in 2013

  5. #5
    Registered User
    Join Date
    11-01-2012
    Location
    Nigeria
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Staff Assessment

    Quote Originally Posted by tehneXus View Post
    there are several possibilities of getting the windows username which then can be compared with the list to remove it, see here: Attachment 239722

    See columns G:K and find the username that represents the user, in the corresponding column heading you'll find the way it has been generated
    How do I get it done???

  6. #6
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Staff Assessment

    Quote Originally Posted by :) Sixthsense :) View Post
    =IFNA() seems to be a new arrival in 2013
    oops, thank for noticing, didn't know that one


    Quote Originally Posted by bolajidopemu View Post
    How do I get it done???
    When you open the workbook click "Enable Content" at the top, then there is code in the file which will fill H3:K4 automatically.
    Then tell me in which column the proper name is displayed which we will use to compare with the drop down list to hide yourself

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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