Linking two seperate date columns to a numerical value
I have a problem with Excel. i have a set of atapoints each dated with ta seperat date row.
I want to link a seperate row of prices (all of which are dated themselves) to these datapoints.
Because there are almost 10000 datapoints with data over 20 years, this would take too long to do by hand.
If anyone knows a smart workaround i would be most grateful!
ps. i have included a screenshot of my dataset to clarify my problem.
Welcome to the Forum.
Can you attach a sample workbook with the sample data AND an example or few that you have typed in by hand so we can see what you are trying to do?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Here you go
In which cells are you trying to create a formula?
Where is the data you are trying to compare against?
Am I missing the SOLVED example?
TRY
=INDEX($P$2:$P$10,MATCH(MONTH(I2)&YEAR(I2),MONTH($O$2:$O$10)&YEAR($O$2:$O$10),0))
Enter with Ctrl+Shift+Enter
Assumption that data in O is in ascending (date) order
Another way. Does not have to be array-entered.Formula:
Please Login or Register to view this content.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks