Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    A Better Way to Calculate (Excel 2002)

    I apologize is this shows up a second time. I posted once and it did not appear to get posted.

    In the attached sheet there are a number of interview dates. In reality the sheet actually covers three months. What the Manager was looking for was the number of interviews on each date. I used a countif formula at the end of each date. Obviously this was time consuming but as it was a rush job, I had to come up with some figures. There must be a better way. Correct?

    Once imported from a specialized program, all interview dates stretched down column A for a number of rows. Is there a method to have all of January's information appear in columns A through to the last day in January, and then below the January data have February's data placed from column A through to the last day in Feb; followed by March?

    Note that the number of interviews per day could be as few as 10 or more than 50.

    Thanks

    Thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: A Better Way to Calculate (Excel 2002)

    In D1 enter:
    1/4/2005

    In D2:
    +D1+1
    Copy D2 to D3: D10 (gets the dates you nee, expand as needed)

    In E1:
    =COUNTIF(A:A,D1)

    Copy E1 to E2:E10

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: A Better Way to Calculate (Excel 2002)

    You did post it before - in the FrontPage forum, in <post:=547,839>post 547,839</post:>. I have now locked that thread, with a link to this one.

  4. #4
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Better Way to Calculate (Excel 2002)

    Boy, I must be sleeping. Sorry.

  5. #5
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A Better Way to Calculate (Excel 2002)

    Thanks.

Posting Permissions

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