Results 1 to 8 of 8

Summarise 100,000 lines of data

Threaded View

  1. 10-09-2014, 02:36 AM #1
    BRISBANEBOB
    BRISBANEBOB is offline
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Summarise 100,000 lines of data

    I am trying to summarise recurring blocks of data which occur at regular iteravals within 100,000 lines of data. Each array contains the costs by cost code (up to 30)and properties (2,000). Help! I have attempted indexation and =mod but I'm not even coming close.

    Any help very much appreciated - a data sample spreadsheet is below.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Summarise data
    By harignz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-05-2014, 03:35 AM
  2. Summarise data
    By NWSIT in forum Excel General
    Replies: 2
    Last Post: 11-30-2010, 02:42 PM
  3. Pie chart to summarise data
    By t0v3 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-08-2008, 11:05 AM
  4. How do you summarise data from two columes
    By drgogo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2008, 12:13 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1