Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Many thanks for that Tom, works a treat!
I'm fairly new to macros, but I should be able to read up on Sumif an modify the code accordingly, if for example, the range doesn't start i A1, or I need the search word (eg. "petrol") to be be specified in cell, shouldn't I? Thanks again for your help, very much appreciated. Kind regards Nei -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |