Results 1 to 6 of 6

Excel 2007 : Dynamic range/average issue?

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2008
    Location
    Colorado
    Posts
    89

    Dynamic range/average issue?

    I need the average of each 1500 rows in a single column with 100,000 rows of data!
    I can use one column to say (b1=1500) then (b2 = b1+1500) and drag down until I get to 100k. Now, how can I write a function to take the average from Average(A"b1":A"b2")

    Understand my question or is there an easier way to get the these averages?
    Last edited by gannon_w; 02-26-2012 at 10:42 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1