I have two sheets

Sheet one column a is student's name, colums b thru k are a point system
ranging from 1 to 3 points column l is the total of columns b thru k (no more
than 30 points total).

Sheet two has 5 columns. Each column is worth 6 points i.e. column a is 25
thru 30 points, column b is 19 thru 24 points, column c is 13 thru 18, column
d is 7 thru 12 points and column e is 0 thru 6 points. I need the total on
sheet one column l to move that student's name in that row to sheet 2 into
the respective column of total points.

Set up the second sheet with the lower limit for the 6-point
ranges in row 1, as:
A B C D E
1 25 19 13 7 0

Assuming names start on row 2 on Sheet1, use these formulas
on sheet 2:

A2 =IF(Sheet1!$L2=E$1,Sheet1!$A2,"")
B2 =IF(AND(Sheet1!$L2=B$1,Sheet!!$L2<A$1),Sheet1!$A2 ,"")
fill the 2nd formula on over through C2:E2
then fill all 5 formulas on down the sheet to capture all
names on Sheet1.


"vaughn01" wrote:

I have two sheets

Sheet one column a is student's name, colums b thru k are a point system
ranging from 1 to 3 points column l is the total of columns b thru k (no more
than 30 points total).

Sheet two has 5 columns. Each column is worth 6 points i.e. column a is 25
thru 30 points, column b is 19 thru 24 points, column c is 13 thru 18, column
d is 7 thru 12 points and column e is 0 thru 6 points. I need the total on
sheet one column l to move that student's name in that row to sheet 2 into
the respective column of total points.