Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Need More Help....Cont-

  1. #1
    Guest

    Default

    Here is the lookup table I am using.
    column A Column B Column C
    DUTY CODES SHRED CODES EXPLANATION
    11 Direct Labor REG
    411 Over Time OT
    611 Compensate CT
    12 Direct TDY
    26 30 Shop Clean-up SHPC
    26 66 Tool Control TCIS
    27 1 Training TRNG
    29 Union Activities UNIN
    31 Annual Leave AL
    32 Sick Leave SL
    33 44 Holiday HOL
    38 Compensatory Leave CTL
    What I explained earlier, I would like for a blank to appear whenever a number that is not on the lookup table is entered in column f6, but I got a #N/a instead.
    Below is a small sample of my excel sheet that I use for time.

    col a col b col c col d
    date code hrs type code

    ______________________________
    M 3-1-02 | 27 | 2.5 | TRNG
    M 3-1-02 | 11 | 2.5 | (REG)Work is Blank
    M 3-1-02 | 31 | 3 | AL
    T 3-2-02 | 11 | 8 |
    W 3-3-02 | 11 | 2 |
    w 3-3-02 | 27 | 2 |Inserted extra line
    W 3-3-02 | 32 | 4 | SL

    NOW For Part 2!!!

    I also need a formula to total each day's hours, not to exceed 8 hrs, unless OT code is in col B, What the problem is, I have a summary sheet by day which shows only if I was off for Sick Leave or Annual Leave. Each line is used for a single day. I do not know how to write a formula to look at more than one line if that date goes beyond one line.
    If a line is inserted in the above form my AL will move one day later or not appear at all.
    # Pay Period...... M T W T F / M T W T F
    06 Mar 24 Apr 06.. 3 4
    07 Apr 07 Apr 20..
    08 Apr 21 May 04..
    09 May 05 May 18..
    10 May 19 Jun 01..

    HELP,

    Thanks
    Walter

    If you want, I will sent you part of the woorkbook to anyone who can give me more pointers on this.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Send me the book I have time for time
    "Have a good time......all the time"
    Ian Mac

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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