Counting the number of times a word appears 'anywhere' on a page
 

I'm trying to clean up a rather large file. The first field of each row
is the name of the row, and if this name does not appear anywhere else
in the file, or in any of three other files, the row can be eliminated.
If it appears 5 times or more, it should be marked as such.

So I'm looking for a way to search for the contents of the first row in
the entire page and three other pages (minus the field containing the
name I'm searching for in the first place) and return the number of
hits. I'm sure there is an easy way to do this, but I haven't managed
to figure it out yet and time is precious in a computer lab.

I'm using Excel 2000 (localised Dutch version).

Thanks for your help!


--
Brother Laz
------------------------------------------------------------------------
Brother Laz's Profile: http://www.excelforum.com/member.php...o&userid=35521
View this thread: http://www.excelforum.com/showthread...hreadid=552919

Counting the number of times a word appears 'anywhere' on a page
 

you might look in the vba help index for FIND and specifically FINDNEXT.
There is a good example you should be able to modify to suit.

--
Don Guillett
SalesAid Software

"Brother Laz"
wrote in message
...

I'm trying to clean up a rather large file. The first field of each row
is the name of the row, and if this name does not appear anywhere else
in the file, or in any of three other files, the row can be eliminated.
If it appears 5 times or more, it should be marked as such.

So I'm looking for a way to search for the contents of the first row in
the entire page and three other pages (minus the field containing the
name I'm searching for in the first place) and return the number of
hits. I'm sure there is an easy way to do this, but I haven't managed
to figure it out yet and time is precious in a computer lab.

I'm using Excel 2000 (localised Dutch version).

Thanks for your help!


--
Brother Laz
------------------------------------------------------------------------
Brother Laz's Profile:
http://www.excelforum.com/member.php...o&userid=35521
View this thread: http://www.excelforum.com/showthread...hreadid=552919