how do i move columns on one sheet to columns on another sheet
I have sheet one which is column "A" student's name columns "B thru K" are a
point system in each column (by 3 points either a score of 1, 2 or 3). Column "L" is the total points summed across "B" thru "K". (a total of no more than 30). Sheet 2 is 5 columns with each column being worth 6 points. Column "A" is 25 thru 30 points, column "B" is 19 thru 24 points, column "C" is 13 thru 18 points, column "D" is 7 thru 12 points and column "E" is 0 thru 6 ponts. I need column "L" on sheet one to move the students name on that row to sheet 2 into the appropriate column based on his/her respective score. |
how do i move columns on one sheet to columns on another sheet
The formulas you want for columns A to E in Sheet2 a
=IF(AND(Sheet1!$L1=25, Sheet1!$L1<=30), Sheet1!$A1, "") =IF(AND(Sheet1!$L1=19, Sheet1!$L1<=24), Sheet1!$A1, "") =IF(AND(Sheet1!$L1=13, Sheet1!$L1<=18), Sheet1!$A1, "") =IF(AND(Sheet1!$L1=7, Sheet1!$L1<=12), Sheet1!$A1, "") =IF(AND(Sheet1!$L1=0, Sheet1!$L1<=6), Sheet1!$A1, "") Cheers, Rob On 14-Dec-2009 19:20, vaughn01 wrote: I have sheet one which is column "A" student's name columns "B thru K" are a point system in each column (by 3 points either a score of 1, 2 or 3). Column "L" is the total points summed across "B" thru "K". (a total of no more than 30). Sheet 2 is 5 columns with each column being worth 6 points. Column "A" is 25 thru 30 points, column "B" is 19 thru 24 points, column "C" is 13 thru 18 points, column "D" is 7 thru 12 points and column "E" is 0 thru 6 ponts. I need column "L" on sheet one to move the students name on that row to sheet 2 into the appropriate column based on his/her respective score. |
All times are GMT +1. The time now is 11:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com