Results 1 to 9 of 9

Develop a VBA code to get the output - find the mean of every 50 lines of row data.

Threaded View

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    41

    Thumbs up Develop a VBA code to get the output - find the mean of every 50 lines of row data.

    Hello Friends,

    I have a very big file with lots of data - more than 300000 rows of data (Columns data until "FU")

    So, I plan to summarize it in short by having the mean/average value of every 50 rows of data.

    Can somebody help me generating the code for finding average of every 50 row.

    Below is the attached file. (Could not attach the complete data because of upload limit)

    Thanks in advance.

    Regards,
    Cadcraft
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combine 2 vba code make one output from data base
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2013, 10:54 AM
  2. Vba code to output the text box containing selected data with comma.
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-29-2013, 09:13 AM
  3. Seeking programmer to help develop code for my company's order entry system
    By Ra1nMantis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2013, 05:04 PM
  4. Code to copy data from multiple sheets into one final output sheet.
    By kenadams378 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 08-03-2012, 08:51 AM
  5. Loop to find a criteria within range, then output results to individual lines
    By bologne in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-17-2011, 12:30 PM

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