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.
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.