Using Excel (No macros) how would we create a repetitive pattern? For example, let's assume we have the list of students in a school, with their class, section and we need to print students' labels with the same fields and "Subject" and Year with blanks (to be filled by students).
A sample label is shown below.
Name: <__________________>
Class: <__________> Section: <________>
Year: <___________> Subject: ________
XYZ School: <_____________>
Now assume we have an excel sheet which contains the student names, their classes and sections as a table (name of school is also available). How do we use the data in the table to create these labels for all the students using formula?
Next Problem
Create a transpose of an excel table with, say, 5 rows and 6 columns.. Use only formulas.. Meaning in the transpose all formula should be the same (I should be able to copy and paste one cell to all other cells (6 rows and 5 columns) and create the transpose)
Now assume we have an excel sheet which contains the student names, their classes and sections as a table (name of school is also available). How do we use the data in the table to create these labels for all the students using formula?
Next Problem
Create a transpose of an excel table with, say, 5 rows and 6 columns.. Use only formulas.. Meaning in the transpose all formula should be the same (I should be able to copy and paste one cell to all other cells (6 rows and 5 columns) and create the transpose)
No comments:
Post a Comment