|
|
#1
05-02-2012, 04:42 PM
|
|||
|
|||
Calculations based off of unsorted data
I have a column that has various repeated dates. I am trying to base calculations off of groupings from the dates.
IRN Name Start Status 3 Week / Orientation / Attendance Wk1 Wk2 Wk3 Pass 1 01/00/00 0 2 0 01/00/00 0 3 0 01/00/00 0 4 0 01/00/00 0 5 01/00/00 0 So I need a way to group the start dates and associated data from columns wk1, wk2, wk3 so I can preform calculations on this data. e.g. I have three student who started 2 weeks ago and 3 students that started a week ago. I need to calculate percentages who posted on wk1, wk2 and so on without affecting the calculations of students who started earlier or later. The only thing I can think of is nested if statements. Last edited by custermd; 05-02-2012 at 04:45 PM. Reason: FORMAT PASTE ISSUE 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditional color fill based on presence of data
|
avanderh | Excel | 11 | 07-28-2011 09:10 AM |
|
Add/Delete data in a Document based on User info
|
vishal17 | Word | 5 | 04-14-2011 05:02 PM |
| Is there a way to do this? (automatically enter text based on form data) | TIKKI555 | Word | 0 | 05-26-2010 09:21 AM |
|
Can I do calculations with times?
|
cubsfan_1 | Excel | 1 | 01-14-2010 06:55 PM |
Windows 7 
Office 2007
Threaded Mode