Thread: to group in small range, and count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default to group in small range, and count
Hi Carolina,
You could use Data, Subtotal

http://www.datapigtechnologies.com/ExcelMain.htm
see Basics fo Subtotals
the link there is a Flash 8 presentation

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Carolina" wrote in message ...
I have a group of years, and I want to group in range, and then I want to
excel count the numbers that belongs to each range. How I do it?


Reply With QuoteReply With Quote