View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tamil Tamil is offline
external usenet poster
 
Posts: 6
Default How to Summarize between step?

I have data sets like 1-2, 2-3, 3-5, 6-10. I want to extract 1-7 step
interval, this should be (1-2)=1+(2-3)=1+(3-5)=2+(6-7)=1 will be a
total of 5. This way, I have bulk data and want to extract many step
intervals. Any short cut method of macro or good formula will be very
useful to me. Thanks in advance.
- Panneer