Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Averaging intervals of data KK Excel Discussion (Misc queries) 1 June 12th 09 10:59 PM
Averaging data with errors John Mac Excel Worksheet Functions 4 July 25th 07 08:10 PM
averaging data James Excel Discussion (Misc queries) 10 December 11th 06 03:12 AM
Averaging data Capt Bill Excel Worksheet Functions 2 March 27th 06 10:13 AM
incremental averaging of data ndflyguy Excel Discussion (Misc queries) 1 October 27th 05 04:50 PM


All times are GMT +1. The time now is 01:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"