Sunday, January 15, 2017

Repetitive Patterns In Excel

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)

No comments:

Post a Comment

Popular Posts

Featured Post

Whom Do We Trust

I came across this: APNews being the trusted source of news for half the world.  And there is Truth Social which also is read and trusted by...