| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I make Excel return the text in column A only if there is.
Seems simple to me but I can't pull it off!!!
I'm trying to have my spreadsheet return the text value of sheet 1, column A. Only if there is a value in column C. Sounds easy enough but I have 30 value's on sheet one that need to spread to sheets 2,3,and 4 which only have room for 10 values each. Is there a formula that will allow me to search the 30 rows in sheet one and return only the 10 which contain a value in column C |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
| how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
| Can you sort text in a column, but leave cell color alone? | New Users to Excel | |||
Threaded Mode
