Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating % formula help for log file.
Hi
What i would like to do is to add entries to a log file on a daily basis. At the end of each entry put one of four main reason codes for the error. At the bottom of the worksheet list the error codes A - D and beside each one have a percentage of each of the errors. I know it sounds confusing so i have included a screen shot of what i mean. For sample purposes i made it easy by having the percentages as 25% each. If "A" had 10 entries "B" had 14 and so on how can i create a formula to reflect that at the bottom of the worksheet. thanks http://i117.photobucket.com/albums/o...bware/asas.jpg |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating % formula help for log file.
Try this:
A12:A15 = error code description =IF(COUNTA(D$1:D$10),COUNTIF(D$1:D$10,LEFT(A12))/COUNTA(D$1:D$10),"") Copy down as needed and format as % Biff "Zilla" wrote in message oups.com... Hi What i would like to do is to add entries to a log file on a daily basis. At the end of each entry put one of four main reason codes for the error. At the bottom of the worksheet list the error codes A - D and beside each one have a percentage of each of the errors. I know it sounds confusing so i have included a screen shot of what i mean. For sample purposes i made it easy by having the percentages as 25% each. If "A" had 10 entries "B" had 14 and so on how can i create a formula to reflect that at the bottom of the worksheet. thanks http://i117.photobucket.com/albums/o...bware/asas.jpg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
Filling Text from Another File | Excel Worksheet Functions | |||
quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
how to reference external refereces from a list | Excel Worksheet Functions | |||
Creating a PDF file programatically from Excel | Excel Discussion (Misc queries) |