B
barkiny
There are two companies (Company A and Company B)
and their earnings announcement dates are different
In the attached file, there is matrix about periods, announcent dates
and the data (Net profit margin) for an example....
I want to find out:
i want to pick a random date, and it will bring the net profit margin
of the company..
of course the random dates are not the same as announcent dates and
when a random date is higher than announcement date it will bring the
latest announcent data,, you can see in attached file
thanks in advance
Barkin
+-------------------------------------------------------------------+
|Filename: data.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4736 |
+-------------------------------------------------------------------+
and their earnings announcement dates are different
In the attached file, there is matrix about periods, announcent dates
and the data (Net profit margin) for an example....
I want to find out:
i want to pick a random date, and it will bring the net profit margin
of the company..
of course the random dates are not the same as announcent dates and
when a random date is higher than announcement date it will bring the
latest announcent data,, you can see in attached file
thanks in advance
Barkin
+-------------------------------------------------------------------+
|Filename: data.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4736 |
+-------------------------------------------------------------------+