Dates into percentages

R

Rick Rothstein

Okay, label Column BX as appropriate (maybe "Total Elements To Be Completed
by Student" or words to that effect) and place the total elements the
student will be completing in that column (that is, type in 28, 34, or
whatever number of total elements the student is scheduled to do). We will
make Column BY your "Percentage Complete" column (you can label it that if
you wish). Put this formula in BY8 and copy it down to the end of your
student list...

=COUNTA(H8:BW8)/BX8

and use Format/Cells to format those cells in Column BY as Percentage.
 
C

CelticCharmer

Hi Rick
Thank you very very much for your help. A good job it works very well again
a big thank you.
Celtic Charmer ;-)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Result Template 0
C# Skype silent connection 0
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Combine rows to print on one label 2
Combining rows 4
Referencing Data listed Vertically into Horizontal Table 6
one row won't calculate 21
Assigning values to a variable set 1

Top