It is very easy to display a vertical result (in row) but sometimes, I need to show the same result in horizontal (in column).
When I use the formula ?
Every time I need to show the results in column instead in row.
How to use the formula ?
The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".
How are the formulas ?
=INDEX()
=ROWS()
As you can see in the picture above, the orange section is displaying the results of the row 2 in vertical with this simple formula “=B2”, very easy so need more explanation.
Now as shown in the other picture, the green section is displaying the results of the row 2 in horizontal with this formula:
=INDEX($2:$2,ROWS(B$2:B2)+1)
If you put this formula in the sheet2 and the results are in the sheet1, the formula is:
=INDEX(Sheet1!$2:$2,ROWS(Sheet1!B$2:B2)+1)
Explanation
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...