Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2004
    Thanked 0 Times in 0 Posts

    Excel Look up Function (Excel 2000)

    I have a spreadsheet that I use for nurse scheduling with names down column A, dates in row 1 and shifts indicated by 7, 3 & 11 in the body of the spreadsheet. I would like to get a list of who is working each date and shift i.e. Joan H 3, Vicki 7 etc for each day on the spreadsheet.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Salt Lake City, Utah, USA
    Thanked 6 Times in 6 Posts

    Re: Excel Look up Function (Excel 2000)

    Have you looked at the Data | Sort and Data | Filter functions? have you looked at Data | Pivot Tables for more complex data analyses?

    It might be helpful if you make a copy of the spreadsheet, cut down in size and censored of any confidential data (use fake names, etc.), and then attach it to your original post, otherwise Loungers are guessing about the actual data layout.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts