Dear All,
I attach the file with my data. I have the following formula which selects the very first observation in each minute:
=IF((A2=MIN(IF(HOUR($A$2:$A$150)&MINUTE($A$2:$A$150)=HOUR($A2)&MINUTE($A2),$A$2:$A$150))*(COUNTIF($A$2:$A2,$A2)=(COUNTIF($A$2:$A150,MIN(IF(HOUR($A$2:$A$150)&MINUTE($A$2:$A$150)=HOUR($A2)&MINUTE($A2),$A$2:$A$150)))))),B2,"")
So for 09:04 it displays the first value (the one that occured first) and so on. What I need is a modification of this formula to display the first value over a 5-minute interval. For example, it starts from 09:04:48 (when the first price occured) and displays the first value over the interval 09:04:48 - 09:09:48, then it continues with the next 5-minute interval. Any help will be really appreciated! Thanks in advance
Bookmarks