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
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.
Any help would be appreciated.
Related:
- Column to text
- How to delete column in word - Guide
- Tweetdeck expand column - Guide
- Excel count occurrences of string in column - Guide
- Excel vba find last non empty cell in column - Guide
- Excel column to index number - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 26, 2010 at 06:47 PM
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)
It seem all you have to do on c27 add formula
=IF(b3="", "", B3)
