Thread: How to average data with a dynamic range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sharon Sharon is offline
external usenet poster
  
Posts: 183
Default How to average data with a dynamic range
Here is the problem I have

Col1 Col2
2.3 1
3.4 1
5.6 1
7.8 2
2.3 2
5.7 2
6.1 3
3.2 3

I want average the value in col 1 only when they have the same number in
col2.
please help! Thanks!
Reply With QuoteReply With Quote