Column to text

Closed
Matt - May 26, 2010 at 04:39 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- May 26, 2010 at 06:47 PM
Hello, I have created a matrix and am attempting to link my column B with my Row 27. For example column B3 would read Robert and Row 27 C would also read Robert, column B4 would read Stan and Row 27 E would also read Stan - similar to a milage chart, I want to get the text entered in the column B3, B4, B5, etc to instantly appear in row 27, column D, E, F, etc. In Row 28 I would like a total of the column to appear.

Any help would be appreciated.

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
May 26, 2010 at 06:47 PM
Not sure what you are asking

It seem all you have to do on c27 add formula

=IF(b3="", "", B3)
0