+ Reply to Thread
Results 1 to 4 of 4

Vacation Schedule Based on Ranking (Seniority)

Hybrid View

nickmessick1 Vacation Schedule Based on... 08-01-2014, 02:05 PM
shg Re: Vacation Schedule Based... 08-01-2014, 02:21 PM
nickmessick1 Re: Vacation Schedule Based... 08-01-2014, 02:34 PM
shg Re: Vacation Schedule Based... 08-01-2014, 02:35 PM
  1. 08-01-2014, 02:21 PM #1
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Vacation Schedule Based on Ranking (Seniority)

    A
    B
    C
    D
    E
    F
    G
    1
    EMPLOYEE
    SENIORITY
    CHOICE 1
    CHOICE 2
    CHOICE 3
    Assign
    2
    JOE
    1
    Jan
    Mar
    Feb
    		 Jan F2: {=INDEX(C2:E2, MATCH(TRUE, COUNTIF(F$1:F1, C2:E2) < 2, 0))}
    3
    BILL
    2
    Jan
    Mar
    Feb
    		 Jan
    4
    CHUCK
    3
    Jan
    Mar
    Feb
    		 Mar
    5
    DAN
    4
    Jan
    Mar
    Feb
    		 Mar
    6
    EDWIN
    5
    Feb
    Apr
    Jan
    		 Feb
    7
    FRANK
    6
    Feb
    Apr
    Jan
    		 Feb
    8
    GEORGE
    7
    Feb
    Jan
    Apr
    		 Apr
    9
    JUSTIN
    8
    Feb
    Jan
    Apr
    		 Apr


    The curly braces mean that the formula MUST be confirmed with Ctrl+Shift+Enter instead of Enter. You can't type in the braces manually.
    Last edited by shg; 08-01-2014 at 02:32 PM.
    Entia non sunt multiplicanda sine necessitate
    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. Accrual Vacation Schedule to Forecast/Note the year Employee Vacation 1-4 weeks is eligibl
    By JackieWood in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-16-2013, 09:05 PM
  2. ranking employees by seniority date
    By Cindylu3 in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 10-02-2008, 04:43 PM
  3. Vacation Schedule
    By mangoodone in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-20-2008, 10:39 AM
  4. Re: Vacation Schedule Grid
    By Tony in forum Excel General
    Replies: 0
    Last Post: 11-02-2005, 06:20 PM
  5. [SOLVED] Re: Vacation Schedule Grid
    By Tony in forum Excel General
    Replies: 0
    Last Post: 11-02-2005, 06:17 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