title: How to convert 1min OHLC data into 5min OHLC data
body: <p>I'm trying to convert 1 minute OHLC (Open/High/Low/Close) data into 5 minute OHLC data in Excel 2013. So far I know the principle. <code>Open</code> has to take the open value every 5 rows, similarly for <code>Close</code>. <code>Min</code>/<code>Max</code> is also understandable. Unfortunately Excel can't understand that I want to get <code>Min</code>/<code>Max</code> from rows 0-5, 5-10 etc. it goes 0-5, 1-6, 2-7 etc. </p>
  
  <p>I was also trying to use AVERAGE somehow but it's pointless since its output doesn't correspond with reality at all. From some more research I think I will have to create a macro from functions AVERAGE, OFFSET, INDEX and MATCH and that's where my struggle begins. I have no idea how to construct that formula.</p>
  
  <p>Here's a picture of how it looks after using Filter on the Count Column:  </p>
  
  <p><img src="https://i.stack.imgur.com/eiRfT.png" alt="enter image description here"></p>