Results 1 to 2 of 2
  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)

    Attached is a partial spreadsheet. The original stretches through to the end of March. The data was imported from another program into Excel and we are concerned with finding the number of entries for each itnerview date. What I did was go to end of each interview date used a countif formula (see attached). This obviously was time consuming, but got the job done for a manager. There has to be a better way! Correct?

    Also as this sheet stretched down column A a long way is there a method of taking all of January data and having it appear in Columns A to through to the end of the number of days on which interviews took place in January. Then a method to take February and place the data beginning in Column A in columns below January; March below February etc.

    Note that the number of interviews varies from day to day. Some as few as 12, others as great as 50.

    Thanks.
    Attached Files Attached Files

  2. #2
    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)

    Is there a special reason you posted this in the FrontPage forum?

    Update: now reposted in Excel as <post:=547,846>post 547,846</post:>. Please post all replies there. This thread is locked to avoid duplication.

Posting Permissions

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