Thread: Calculations based off of unsorted data
View Single Post
 
Old 05-02-2012, 04:42 PM
custermd custermd is offline Windows 7 Office 2007
Novice
  
Join Date: Aug 2010
Posts: 4
custermd is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Help.xlsx (15.5 KB, 10 views)
Last edited by custermd; 05-02-2012 at 04:45 PM. Reason: FORMAT PASTE ISSUE
Reply With Quote