title: Calculating average of range of values in a column dynamically - excel
body: <p>I have many sheets in 1 excel. </p>
  
  <p>Sheet 1: 
  One of the columns in sheet1 looks like this</p>
  
  <pre><code>separator
  14124
  25362
  32
  32387
  23
  23
  separator
  25
  3263
  33
  2
  separator
  25326
  323
  separator
  623
  2362
  233
  88
  separator
  236523
  32
  23
  2323
  232
  23
  23
  223
  2
  </code></pre>
  
  <p>Basically, a range of values are separated by  "separator". I want to take the average of the values between two "separator" and print it out in a separate row in sheet2. 
  I can surely do that manually by highlighting the range of values, but I don't want to do it manually. The range of the values &amp; the location can vary. 
  Is there any way to write a formula to detect the word "separator" &amp; sum up all the range of values between two separator dynamically without selecting the cell range and print them in another row in another sheet? </p>
  
  <p>I can surely write a program in Java because thats what I know. But do we need python or javascript here for this manipulation? Have never used excel manipulation using python etc. Or can we do it in excel? If we need python or js, Can someone give me a rough idea as to how to do this?</p>
  
  <p>Thanks :) </p>