| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return Text from a row of 20+ columns
Hi guys,
I have a table of about 30 columns. In each row, only one cell of the 30 has text in it. What I would like to do is add a column (say AE) and have a formula that looks through column AA1:AD1, finds the cell with text and returns it in AE1. I thought it might be something simple, but I have gottne myself turned around and before I craft some frankenstein spreadsheet, I thought I would ask for help. Thanks, P |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| 2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
| Text to columns with carage return as deliminator | Excel Discussion (Misc queries) | |||
| Text to columns delimited by carriage return | Excel Worksheet Functions | |||
| How do I convert text to columns when there is a carriage return? | Excel Worksheet Functions | |||
Threaded Mode
