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 ?
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:
If you put this formula in the sheet2 and the results are in the sheet1, the formula is:
- 1. $2:$2 is the row where are the results
- 2. B$2:B2 is the column where the results begin
- 3. +1 is to tell the formula that it has to display from the column B. Imagine that your results start from the column C or you want only to display the result from the column C, in this case, put “+2”.