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.

--

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.

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.