Compare and Count data in worksheet rows.
 

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.

Compare and Count data in worksheet rows.
 

hi
the find function will count for you also. if you click the find all button.
the count of the number of cells excel found the item in the select range
will appear in the lower left of the find box.
and as to high lighting if it's new.....how would excel know that? you need
to do that when you enter it new.
but find can color all of your seach items. click the replace tab then click
options
enter your search item. to the right leave "no set fomat"
leave replace with blank. to the right, click the format button. select a
background color or font color, click ok. click replace all.
all search item should be colored up.

regards
FSt1

"jethro71301" wrote:

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.

Compare and Count data in worksheet rows.
 

I was hoping that there was a way to compare the data on the last row entered
with the rest of the selected range to see if the data on the last row was
not entered previously. It was easy review the data manually with 3 weeks of
data, but with a year of data it is difficult.

I just assumed it was possible to locate new data and count in excel. I
guess I must be mistaken. If any one can advise me of a book to learn the
syntax of VBA, I would appreciate it. This is a personal project.

FSt1,
The reply was not really an answer to my question, but thanks anyway.

"FSt1" wrote:

hi
the find function will count for you also. if you click the find all button.
the count of the number of cells excel found the item in the select range
will appear in the lower left of the find box.
and as to high lighting if it's new.....how would excel know that? you need
to do that when you enter it new.
but find can color all of your seach items. click the replace tab then click
options
enter your search item. to the right leave "no set fomat"
leave replace with blank. to the right, click the format button. select a
background color or font color, click ok. click replace all.
all search item should be colored up.

regards
FSt1

"jethro71301" wrote:

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.