Home |
Search |
Today's Posts |
#1
|
|||
|
|||
track daily sales
I would like to be able to track my employees running sales figures on a
daily basis and have a form (or something) that indicates the difference of each employee's numbers against the highest one. For instance: Date Employee Sales Difference ---------------------------------------------------------------- 5/2/05 Debbie R. 505 0 5/2/05 Tim J. 350 155 5/2/05 Matt F. 200 305 etc. If anyone can help, or offer a similar scenario, please advise, ASAP. Thank you very much. |
#2
|
|||
|
|||
-- HTH RP (remove nothere from the email address if mailing direct) " wrote in message ... I would like to be able to track my employees running sales figures on a daily basis and have a form (or something) that indicates the difference of each employee's numbers against the highest one. For instance: Date Employee Sales Difference ---------------------------------------------------------------- 5/2/05 Debbie R. 505 0 5/2/05 Tim J. 350 155 5/2/05 Matt F. 200 305 etc. If anyone can help, or offer a similar scenario, please advise, ASAP. Thank you very much. |
#3
|
|||
|
|||
For Debbie,
=MAX($C$2:$C$100)-C2 and copy down -- HTH RP (remove nothere from the email address if mailing direct) " wrote in message ... I would like to be able to track my employees running sales figures on a daily basis and have a form (or something) that indicates the difference of each employee's numbers against the highest one. For instance: Date Employee Sales Difference ---------------------------------------------------------------- 5/2/05 Debbie R. 505 0 5/2/05 Tim J. 350 155 5/2/05 Matt F. 200 305 etc. If anyone can help, or offer a similar scenario, please advise, ASAP. Thank you very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to calculate sales tax from total sales | Excel Worksheet Functions | |||
I need a daily sales sheet to pull from monthly figures sheet | Excel Worksheet Functions | |||
Trying to create a Sales Projection/Forecast/Estimate | Excel Discussion (Misc queries) | |||
Teplate to Track sales of multiple products on per client basis. | Excel Discussion (Misc queries) | |||
Help with Commission forumlas | Excel Worksheet Functions |