| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find text in column h and total the corresponding numbers if colum
hello
i am a total newb to macros/vb. my problem is . Weekly I receive a speadsheet in which column H contains randomly entered words depicting work performed by an individual in different areas of their work. in column D is the total amount of time taken for that piece of work. I wish to search column H for a specific string and then total the corresponding entry in column d to work out how much time was spent on the searched for item. make sense? can anyone help me with this? thank you in anticipation. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Add total number of rows (text) in a column | Excel Worksheet Functions | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| Find the combination of numbers that when added equal a reqired total?? | Excel Worksheet Functions | |||
| I NEED TO SUM NUMBERS ON A COLUMN THAT HAVE TEXT AND NUMBERS | Excel Worksheet Functions | |||
Threaded Mode
