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.

Column to text
Excel copy column from one sheet to another automatically - Guide
Sum column if another column equals ✓ - Excel Forum
How to increment numbers when value changes in another column? - Excel Forum
Auto serial number in excel based on another column ✓ - Excel Forum
Excel partial text match between two columns - Guide

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)

Similar discussions

VBA find column by name and sort

Converting rows of data in notepad to columns

Auto generate serial number in excel based on Column

How to copy the Column value into Rows

Counting number of times a value appears if..

Similar discussions

Subscribe To Our Newsletter!