Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
training tracker
I am tracking training for my unit using an Excel sheet put out by the
military (must use). The columns are each seperate training class and the rows are the individuals. Each class has a Shelf life (must be completed with in a certain date. That date<MOB=mobilization is solid and does not change, all the other columns go off that cell) I have placed a conditional format on each column that changes the color when they date corresponds to a designated shelf life (Green good red falls out or expired). I have a YES/NO column that states if the individual is deploying. At the bottom of each column is a Number trained (COUNTA formula) that gives a quick snap shot of how many has conducted the training. for the information r3 refers to Row 3 due to the way the table was designed. r6 NAME dploying class r7 john no 1/oct/08 <grn r700 bill yes 1/oct/08 <grn r800 mary yes 1/aug/o8 <red r801 deploying=2 trained =3 total people=793 I would like to know: 1) how to get the number trained and filter out the NO's in deploying to let me know of all those who are going are trained (some individuals in the class are not going but have to participate for accountability). 2) How to get the number trained that correspond to the shelf life (green for good, red for bad <color coresponds to date and the longetivity of the shelf life). Is there a way to count the Conditional Format colors?(if 100 people trained, say 40 are greeen and 60 are another color is there a way to count just the Greens?) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
training tracker
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
training tracker
thanks for the sheet it is getting me there.
At the bottom of the sheet (I have no idea ho to send it bakc or post it like you did) c3 c4 r53 yes= 27 <=COUNTIF(Deploying,"yes") r54 no= 21 <=COUNTIF(Deploying,"no") Since in my sheet each column is a training event I should just add a column, hid it and use the formula =--(ClassEnd<MOB)*(Deploying="Yes") my MOB date is one cell with the actual date. WOuld I need to make it a column to each person (mob column) or can I use the cell in the formula. eg. cell is C4 that states 1 june 09 would the formula then look like =--(ClassEnd<C4)*(Deploying="Yes") ? Thanks for the input, it is getting me closer and that is a relief. ~Dice "Herbert Seidenberg" wrote: Excel 2007 http://www.mediafire.com/file/1tn2tz...12_03_08b.xlsx |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
training tracker
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tracker | Excel Worksheet Functions | |||
Frequency tracker | Excel Discussion (Misc queries) | |||
Mileage Tracker | Excel Discussion (Misc queries) | |||
MIS tracker | Excel Worksheet Functions | |||
attendance tracker | Excel Discussion (Misc queries) |