Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: I need alot more help...

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Macon, Georgia USA
    Posts
    158
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In block c6 to c9 I have one date,
    In block e6 to e9 the total is 8.
    In block f6 to f9 I am looking for one of three codes.
    What formula do you use when you need to look at c6 to c9 for the date.
    look at e6 to e9 for the hours to total 8.
    look for one of the three codes in the same blocks, for only one block.

    I tried countif and it did not help. Anymore ideas.
    I can e-mail a part copy of the project I am working on, to see if you all can improve on my personal project.

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-08 11:41, TiggerToo wrote:
    In block c6 to c9 I have one date,
    In block e6 to e9 the total is 8.
    In block f6 to f9 I am looking for one of three codes.
    What formula do you use when you need to look at c6 to c9 for the date.
    look at e6 to e9 for the hours to total 8.
    look for one of the three codes in the same blocks, for only one block.

    I tried countif and it did not help. Anymore ideas.
    I can e-mail a part copy of the project I am working on, to see if you all can improve on my personal project.
    Are you looking to determine if C6 is a certain data AND E6 is 8 AND F6 is one of three codes? And then do the same for row 7, 8 and 9?
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Macon, Georgia USA
    Posts
    158
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Barry,
    I need all the help I can get with this project I took on myself, because I did not know if the timekeepers would keep my time straight. So I started making a form that I thought would be simple, but NOT.
    If you or anyone would be so kind and look at my past posting, I would deeply be app...
    or if you want me to e-mail you a copy. I could
    Thank alot,
    Walter

  4. #4
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-08 18:33, TiggerToo wrote:
    Barry,
    I need all the help I can get with this project I took on myself, because I did not know if the timekeepers would keep my time straight. So I started making a form that I thought would be simple, but NOT.
    If you or anyone would be so kind and look at my past posting, I would deeply be app...
    or if you want me to e-mail you a copy. I could
    Thank alot,
    Walter
    Walter, go ahead and e-mail me a copy of your spreadsheet. Please include a concise description of your requirements.

    Regards,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

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
  •