Results 1 to 5 of 5

match date name and specific shift and return date in other cell

Threaded View

godlev match date name and specific... 06-29-2016, 12:00 PM
Jacc Re: match date name and... 06-29-2016, 12:40 PM
Jacc Re: match date name and... 06-29-2016, 12:43 PM
godlev Re: match date name and... 06-30-2016, 04:16 AM
Jacc Re: match date name and... 06-30-2016, 05:41 AM
  1. #1
    Registered User
    Join Date
    09-02-2011
    Location
    Bulgaria
    MS-Off Ver
    2013
    Posts
    91

    Question match date name and specific shift and return date in other cell

    Hello friends
    i have a team schedule which we use to track the team absence
    from time to time i want to check which dates exactly someone from the team was in specific absence which we mark with C
    on the tab schedule we have column A with the names
    Row 1 and 2 with the dates
    the crossing cells are the corresponding shifts


    i wanted to make a array formula to list only C entries for certain person in compensations tab but i was not able to compile something to work properly.

    i would appreciate your help if you help me find formula or VBA to fill in the yellow cells in compensations tab with the dates which the corresponding name on top was assigned to C shift
    Attached Files Attached Files
    Truth fears no questions.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 9
    Last Post: 10-08-2015, 01:50 PM
  2. [SOLVED] Return a specific date based on another cell
    By karstens in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2015, 05:27 PM
  3. [SOLVED] How to Match or Lookup the the qty to other specific cell that match the date
    By JESSHOR60 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-11-2015, 04:20 AM
  4. Replies: 2
    Last Post: 08-16-2013, 10:18 AM
  5. Replies: 5
    Last Post: 02-10-2012, 12:52 PM
  6. Replies: 6
    Last Post: 03-05-2008, 02:58 PM
  7. Date Function formula that will return the date of a specific week
    By Greg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2006, 12:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1