Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro query - finding mutliple occurences of text in a column
Hi all
I have a list of various words in a column and a correspondin numerical value for it in an adjacent column. I would like a macro that "scans" down the column of words and adds th corresponding numerical values for a particular word (see attache file). For example in the attached file it could look for the wor "petrol" and add 20 and 15 to return 35. I've had a stab at a macro involving "find", "match", "offset" etc wit no joy... I wondered if anyone would be able to post suitable cod suggestions? Eventually I'd like for the search word (eg. "petrol") to be specifie in a list and the macro to search for all words in a list - is thi possible? Any help would be much appreciated. Apologies that I posted a simila thread - I don't think my query was very clear. I'm very keen t automate this in a macro and steer clear of pivot tables! Many thanks for your time. Nei Attachment filename: neilmacro.xls Download attachment: http://www.excelforum.com/attachment.php?postid=66550 -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Unique occurences of text in a column | Excel Worksheet Functions | |||
Counting Unique occurences of text in a column | Excel Worksheet Functions | |||
How do I count the # of unique occurences of a text in a column? | Excel Worksheet Functions | |||
count text occurences in a column | Excel Discussion (Misc queries) | |||
Excel Macro Query - Search for specific text in cells of a column | Excel Programming |