View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Stock Market data issue

Thank you for your kind words. And to think that I made the mistake
often made by responders here, I read only the first half of your post.
In particular, I did not see that you had your data broken in 4
columns. Is this the issue? If so, my formula can be readjusted for
your case.

What you say in your reply is now confusing me. If you can elaborate
what you mean by 'count' from specific cells forward. Without being
sure, one function that 'counts' forward from a specific cell, say 5
cells, is

OFFSET(A1,0,0,5,1)

Here, if the specific cell is A1, the specific call to OFFSET returns a
range of 5 cells starting from A1. Sometimes, in some calculations, you
need to use

N(OFFSET(A1,0,0,5,1))

Does this help? If you want you can return with a more specific
explanation.

Kostis