Important!!! Need Info on creating a percentage.

  • Thread starter Thread starter msnews.microsoft.com
  • Start date Start date
M

msnews.microsoft.com

Thank you for answering the call!!! I have a rather pressing issue.

I need to input a series of safety violations and then crank out a
percentage.

For example I need to input a number of work stoppages. Basic info including
name, date, shift etc... but Most importantly the safety violation (such as;
section 1.23a or 4.56c etc...) cited to explain the work stoppage.

Still with me?

At the end of the day, week, month (whatever...) I need to produce the
percentage of times each particular violation occurred.

Ok so now the burning question: How? Perhaps it would be possible to number
the violations (should be less than 10 different ones) if it makes matters
any simpler.

Thanks in advance!
M.E.
"Drive Thy Business or Thine Business Will Drive Thee."
-Benjamin Franklin
 
List each of the violation codes (once) on a separate list and use the
following formula to the right of the first code on the list:

=COUNTIF($C$1:$C$50,F1)/COUNTA($C$1:$C$50)

Where...

$C$1:$C$50 is the range containing all of the violation codes
F1 is the first violation code on the separate list you need the
percentage for

My assumption is you need to find out what percent of a violation occurred
out of all the violations in $C$1:$C$50. If you're just looking for a count,
use COUNTIF($C$1:$C$50,F1).

Copy the formula down for each violation code on the list.
 
I am a little unclear... Please excuse my ineptitude, I am just a humble web
designer thrown into the lions den...

I think you have the solution, but I am not sure how to implement it. I
believe you understand the problem, but let me clarify the issue.

We are talking about shipping (actually unloading and loading to and from
ships) occasionally a safety issue will be raised that requires work to
stop. I need to record the info on the stoppage and at the end of a set
period determine what percentage of each particular violation occured. Now I
am informed, I will need to determine it per ship as well.

I think I can see what you are trying to do, unfortunately perhaps you have
overestimated my excel abilities... (in other words I need the "For Dummies"
version) Tough to admit but there it is.

Is excel the program that is suited for this or is Access better suited to
the task.

Either way I am not certain how to implement the formulas you gave me.
(Thanks a Million by the way. I appreciate it.)

Best Regards
Marc McCandless
 
Back
Top