Previous Topic Next Topic

Column to text

Closed
Matt - May 26, 2010 at 04:39 PM
rizvisa1 Posts 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
VBA find column by name and sort
SidK -
bOFILL -

4 responses
Converting rows of data in notepad to columns
Need help -
Philgood_FR -

2 responses
How to copy the Column value into Rows
Raj_1562 -
TrowaD -

9 responses
Comparing columns and returning value
ll -
kittu -

35 responses