Here's a sample file:

http://cjoint.com/?hrigq0SBS0

All the formulas needed are array formulas.

How to enter an array formula:

http://cpearson.com/excel/array.htm

Biff

"x3mist" wrote in
message ...

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