Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Macro query - finding mutliple occurences of text in a column

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting Unique occurences of text in a column Tan Excel Worksheet Functions 12 October 26th 09 04:21 PM
Counting Unique occurences of text in a column Bernd P Excel Worksheet Functions 0 October 25th 09 10:47 AM
How do I count the # of unique occurences of a text in a column? Rob Kaiser Excel Worksheet Functions 10 November 21st 07 09:16 PM
count text occurences in a column Daniel_ITSM Excel Discussion (Misc queries) 20 March 7th 07 08:46 PM
Excel Macro Query - Search for specific text in cells of a column Mcneilius Excel Programming 2 August 29th 04 05:12 PM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"