i hope its clearer now that ive uploaded a jpeg showing the problem and
the desired solution. Raw data is the time and price, what is needed
is the open, close, high and low. Time is ascending. Thanks :)


+-------------------------------------------------------------------+
|Filename: excel_print_screen.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=5042 |
+-------------------------------------------------------------------+

--
x3mist
------------------------------------------------------------------------
x3mist's Profile: http://www.excelforum.com/member.php...o&userid=36417
View this thread: http://www.excelforum.com/showthread...hreadid=561896