Hi I have the following data:
stock name month open price close price
A Jan 21.3 22
A Feb 23 21
A March 19 23.5
A Dec 24 26
B Jan 3 3
B Feb 4 5.5
B March 6 8.5
B Dec 11 11.5
How would i get the first value for open price and the last value for close price for each stock using excel vba? For example, stock name A has an open price of 21.3 and a close price of 26 for the full year. The data is already sorted by stock name and month. I have thousands of stock values and need to do it for each one.
Hi xlrv and welcome to the forum,
Instead of using VBA, how about a Pivot table to filter our the other months and only show Jan and Dec. I suggest this because, if you would have used dates instead of month name text, you would have an easy time sorting your data. When you use month names, sorting from earliest to latest is much harder.
See the attached for a suggestion on a non VBA method.
Jan and Dec Open Close prices.xlsm
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Just filter you raw data by Jan & Dec
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks