+ Reply to Thread
Results 1 to 2 of 2

How to pick up hundreds data from thousand points of data (600000).

  1. #1
    Registered User
    Join Date
    07-22-2014
    Location
    Nottingham
    MS-Off Ver
    2010
    Posts
    0

    How to pick up hundreds data from thousand points of data (600000).

    Hi...
    I am dealing with 600000 - 700000 points of data. they show a stress-strain relation.
    As it involves thousands of points, My computer through excel runs very slow. I have been suggested to reduce the data by taking just representative points which are still showing similar look of the graph.

    The data is like below (700000 rows)

    Compressive strain Compressive stress
    (%) (MPa)

    0.00051 0.00021
    0.00051 0.00021
    0.00051 0.00021
    0.00051 0.00021
    0.00051 0.00022
    0.00051 0.00022
    0.00051 0.00022
    0.00051 0.00022
    0.00051 0.00023
    0.00051 0.00023
    0.00051 0.00023
    0.00051 0.00024
    ...

    76.03861 11.68763
    76.03912 11.68776
    76.03912 11.68789
    76.03912 11.68803
    76.03963 11.68816
    76.03963 11.6883
    76.03963 11.68844
    76.04014 11.68859
    76.04014 11.68874

    If I want to have only 10000 points of data but still give the same information as its original plots of 700000.Could someone tell me how to exclude unnecessary data using excel (2010)?

    Many thanks.
    Abdur

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello abdur,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to pick up hundreds data from thousand points of data (600000).
    By abdur in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-22-2014, 10:22 AM
  2. Replies: 6
    Last Post: 03-10-2014, 07:41 PM
  3. [SOLVED] NumberFormat: display thousand seperator and opt. decimal points
    By Klaster in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-19-2013, 11:17 AM
  4. Replies: 0
    Last Post: 02-16-2009, 10:11 AM
  5. Replies: 4
    Last Post: 05-30-2008, 10:39 AM

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