| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Retrieve text content from range with criteria
Is there a way to retrieve the text content of a cell in the same way that a
SUMPRODUCT function will retrieve numeric content? If not is it possible to retrieve the ROW number of the cell in a SUMPRODUCT (?) in order to use it in an INDIRECT function? I need to retrieve content from a cell (both text and numeric) according to a combination of values (criteria) in other cells in the same row. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| Sumproduct-multiple criteria for same range "OR" | Excel Worksheet Functions | |||
| Criteria Range at two different places | Excel Worksheet Functions | |||
| How to I copy text from a range of cells to another single cell? | Excel Discussion (Misc queries) | |||
| Find last occurance of text in range | Excel Worksheet Functions | |||
Threaded Mode
