bananatang
10-09-2009, 07:45 AM
HI,
I really could do with some assistance in solving this situation.
i have a worksheet which contains student data. Each pupil will have a row which contains data relating to their attendance.
Some pupils will have more than one row of data against their name. What i am trying to have is a single row for each student. In order to do that i need to consolodate certain cell values together from each duplicate pupils records into a single record.
Each student will have a Unique pupil No. (UPN, Column E) for easy indentification of all pupils who have more than one row of data.
If a pupil is on the worksheet has more than one row of data
i need column K which is called "Possible Sessions" cell values to be added together for pupils that have the same UPN.
Plus
i need each column from R to AD cell values to be added together.
I would like the new amended cell values to be inserted into the duplicate students row which contains a blank value in cell P which is called On Roll/Off Roll
AND FINALLY
The duplicate pupil rows to be deleted. The rows to be deleted will have a text value called "Off Roll" in column P
I have attached an example for easier understanding.
Thanks
BT
I really could do with some assistance in solving this situation.
i have a worksheet which contains student data. Each pupil will have a row which contains data relating to their attendance.
Some pupils will have more than one row of data against their name. What i am trying to have is a single row for each student. In order to do that i need to consolodate certain cell values together from each duplicate pupils records into a single record.
Each student will have a Unique pupil No. (UPN, Column E) for easy indentification of all pupils who have more than one row of data.
If a pupil is on the worksheet has more than one row of data
i need column K which is called "Possible Sessions" cell values to be added together for pupils that have the same UPN.
Plus
i need each column from R to AD cell values to be added together.
I would like the new amended cell values to be inserted into the duplicate students row which contains a blank value in cell P which is called On Roll/Off Roll
AND FINALLY
The duplicate pupil rows to be deleted. The rows to be deleted will have a text value called "Off Roll" in column P
I have attached an example for easier understanding.
Thanks
BT