Hi,
I enter stock symbol data on a daily basis. The number of symbols per day
will vary with the market strength. The "Find" function in the Excel edit
menu tab will locate where the symbols are located, but it will not count the
number of times the symbols appear. I would like to find a way to count the
number of times each symbol appears in a selected date range. Also if
possiblehighlight the symbol if it is new to the list. My head is spinning.
Below is a sample of the data:

01/02/08 ABB EDU MSFT INTC
01/03/08 EDU INTC ESV PTEN TNE
01/04/08 ABB ESV BIG
Blank Row - between Friday and Monday data
01/07/08 ABB MSFT T

If the macro or program was run between 01/04/08 and 01/07/08

ABB = 2
ESV = 1
BIG = 1
MSFT = 1 Highligt the cell for MSFT since it is new to the list for the
selected range.
T=1 Highlighted since new to list.

If the program was run for all data: between rows 01/02/08 and 01/07/08.
ABB = 3
EDU = 2
MSFT = 2
INTC = 2
ESV = 2
PTEN = 1
TNE = 1
BIG = 1
T = 1 Highlighted since it is new to the data range on the last date
used.(last row selected.)

The "T" symbol cell could be highligted in the current cell indicating it
was new to the range.

I have been looking at the code and posts in this section. But the
questions seem to compare only 2 rows not the entire range between rows. The
syntax is hard to follow. I am not sure how to manipulate the data in excel.
Is there a book out there to read to understand all of the syntax with
examples. Any assistance would appreciated. Thank you.