Thread: Averaging Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FGE-carl FGE-carl is offline
external usenet poster
 
Posts: 1
Default Averaging Data

I have a database set up in excel and I would like to extract data from
certain columns and take an average of that data. However, I need to average
the data in decimal format that is seperated by whole numbers. I need to
eliminate the whole numbers and just take the average of the inbetween data.
Also, the data is always changing and there is no set "Cell Location." I need
to be able to run this with an arbitrary amount of cells.