Excel Tips vol.1
Referencing one cell up
This is useful when you need a series of cells in a category.
1
=INDIRECT(ADDRESS(ROW()-1,COLUMN()))
Add +1 to the number in the cell above it
When you want to create a sequential numbered line from No.1 to 100
1
=MAX(INDIRECT(ADDRESS(1,COLUMN())&":"&ADDRESS(ROW()-1,COLUMN())))+1
Add a line break in a sentence.
Use char(10) for line feed code and & for string concatenation.
1
="Add a line break to this sentence" & char(10) & B5
