Here's what I am basically trying to do:
There is a list of data like this:
Ticker Date
goog 1/2/07
goog 1/3/07
goog 1/4/07
goog 1/5/07
goog 1/8/07
goog 1/9/07
ibm 1/2/07
ibm 1/3/07
ibm 1/4/07
ibm 1/5/07
Basically I need is VBA code to do the following:
Identify the first instance of goog, give me the the row#
Identify the last instance of goog, give me the row#
Identify the first instance of ibm, give me the the row#
Identify the last instance of ibm, give me the row#
I guess what is getting complex for me is the following:
There will not always be two unique stocks, sometimes it could be 2, sometimes it could be 10, or whatever, so do I need to build an array of some sort to get all the unique values in column A (ticker column) and then do some search for first and last instances.
Also, from the example, there won't necessarily be the same number of instances of each stock either.
I hope this makes sense and any help would be much appreciated.
~Gooser
Bookmarks