| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
variable text value within string formula required to sum column
My column D4:D1002 contains text and they could all conceivably be
different. Some of them have words in them that will be the same as in others, for example the word "insurance" might be many different cells within text strings which are unique to that cell, like Norwich Union Insurance or Health Insurance Plan or Insurance or Insurance Fees. I need to pick out those cells and sum the corresponding cell in column F or G, whichever has the figure in it. Any suggestions please? TIA Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Search column and move text formula | Excel Discussion (Misc queries) | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Threaded Mode
