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

Thread: Keeping statistics on 1 sheet based info on another

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can anyone help me?
    In column A I have a date column filled with week ending dates
    In column B, I have 8 digit file numbers regarding promise of payment
    In column C, I have 2 letter code "TO" or "TR"
    In column D, I have employee initials
    In column E, I have a "payment in by date"
    In column F, I have file numbers of disputed accounts
    In column G, I have file numbers for good jobs but no message left.
    In column H, I have Column Labeled "Payment come in?"

    I will be entering info in each of the columns on a daily basis. I would like the following statistics on Sheet 2.

    for each employee (column d)
    1.the number of promises for each week ending date
    2.the number of to's and the total number of tp's per employee by week ending date.
    3. the percentage of "to promises" that came in and the percentage of "tp promises" that came in.



  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi jbyrne. If you've set up your file like a *real* database file, you can just use the Data-Subtotals feature.

    To set it up like a *real* database, you need column headings in Row 1, and first record in Row 2. No completely blank columns and no completely blank rows in your data.
    ~Anne Troy

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,658
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    Care to provide 10 rows of data (including the labels) from your Sheet1? Just select an empty cell, type =, select 10 rows of data, hit F9, copy what you see and post the copied bit in the follow-up.

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
  •