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.
> >
> >
> >
|
Similar Threads
