+ Reply to Thread
Results 1 to 7 of 7

How to determine whether an employee is stiil working for the same company?

  1. 03-27-2024, 08:56 AM #1
    Luu4466
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    175

    How to determine whether an employee is stiil working for the same company?

    Good morning to the community.

    I am working on the file "Test metier".

    In column H of the "Recherche V a faire" tab, I would like to know whether the employee is still with the company or not, by entering "Yes" or "No".
    The search base is established in the "Feuil 1" tab in the cell range A1:Q3.

    Thank you for your help.
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-27-2024, 09:08 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: How to determine whether an employee is stiil working for the same company?

    Note.

    Recherche a2 "Paul " is not a match for "Paul"
    Drizain is spelled differently in the two sheets.


    =IF(A2="","",INDEX(Feuil1!$J$2:$J$10,MATCH(1,(Feuil1!$A$2:$A$10=B2)*(Feuil1!$B$2:$B$10=A2),0)))

    copeid down. Refer to file for French translation.
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 03-27-2024, 09:13 AM #3
    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: How to determine whether an employee is stiil working for the same company?

    Put this formula in H2 and copy down
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Notes:

    • Email address would be the best unique identifier but you do not have any email addresses in Feuil1. Therefore I am using a combination of first and last name.
    • The "=" sign is added to prevent matching errors like "ReneEcole" to "ReneeCole".
    • You have an extra space in A2 ("Paul ") that will prevent a match. If you remove the space you will get "Yes".
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  4. 03-27-2024, 09:40 AM #4
    Luu4466
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    175

    Re: How to determine whether an employee is stiil working for the same company?

    Thank you for your answers @Glenn Kennedy and @6StrigJazzer.
    What could be the formula if the tab is renamed Feuil1 is renamed "2302_Liste contacts SSCO VMK"?
    Reply With QuoteRegister To Reply
  5. 03-27-2024, 09:41 AM #5
    Luu4466
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    175

    Re: How to determine whether an employee is stiil working for the same company?

    Thank you for your answers @Glenn Kennedy and @6StrigJazzer.
    What could be the formula if the tab "Feuil1" is renamed "2302_Liste contacts SSCO VMK"?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 03-27-2024, 09:42 AM #6
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: How to determine whether an employee is stiil working for the same company?

    =IF(A2="","",INDEX('2302_Liste contacts SSCO VMK'!$J$2:$J$10,MATCH(1,('2302_Liste contacts SSCO VMK'!$A$2:$A$10=B2)*('2302_Liste contacts SSCO VMK'!$B$2:$B$10=A2),0)))


    It needs the ' because there are spaces in the Tab name
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 04-07-2024, 01:53 PM #7
    Luu4466
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    175

    Re: How to determine whether an employee is stiil working for the same company?

    Good evening to the community.

    Sorry for the delay.

    I worked on a different file with more names but the structure was the same.
    I found this formula which was able to differentiate between lowercase and uppercase letters.

    FRENCH 
    Please Login or Register  to view this content.
    ENGLISH 
    Please Login or Register  to view this content.

    Thank you.
    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. Working hours employee records, changing only the employee's name while printing the recod
    By Veselko12 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-23-2023, 11:58 AM
  2. Determine if an employee was at the company at a certain date
    By FJDOB in forum Excel General
    Replies: 6
    Last Post: 11-05-2020, 01:25 AM
  3. Move employee data from rows to columns for the same company
    By Carrie4841 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 06-19-2013, 03:09 PM
  4. Hi, need sample format for monthly over time calculation employee in my company
    By deepaksinghrawat in forum Excel General
    Replies: 1
    Last Post: 07-15-2012, 06:13 PM
  5. Runtime Error 1004 in Company Employee Timesheet Spreadsheet
    By mjoseph527 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-07-2009, 04:01 PM
  6. Using FV formula to determine employee retirement plan
    By gomumy97 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2007, 05:40 PM
  7. Workbook Protectionand stiil use Comment function
    By olympiad in forum Excel General
    Replies: 2
    Last Post: 06-25-2005, 10:05 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