+ Reply to Thread
Results 1 to 2 of 2

Reduce Data

  1. #1
    Registered User
    Join Date
    05-12-2020
    Location
    Austria
    MS-Off Ver
    neu
    Posts
    1

    Reduce Data

    Hi,

    I have a very large data set that I would like to reduce for further processing. I would like to keep only every fifth line from a filtered selection. This means that four fifths of the filtered data should be deleted.

    My data set consists of 25 experiments. The first three experiments have 5 times more data than the rest of the experiments. Therefore I only need every 5th measuring point for the first 3 experiments.

    * How can I do that?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: Reduce Data

    Read the yellow banner at the top of this page for instructions on how to upload a sample file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Reduce Rows with Data
    By Vixx1 in forum Excel General
    Replies: 2
    Last Post: 08-16-2019, 07:18 AM
  2. [SOLVED] How to reduce a large group of data
    By Kjiel in forum Excel General
    Replies: 6
    Last Post: 12-12-2018, 03:50 PM
  3. Replies: 1
    Last Post: 12-17-2013, 03:18 PM
  4. Reduce the big file deleting unncessary data
    By jdbaba in forum Excel General
    Replies: 0
    Last Post: 02-02-2012, 09:25 PM
  5. Require macro to reduce data by averaging
    By dpgillies in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2010, 08:53 AM
  6. How do I reduce the number of data points I have??
    By ssanjan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-31-2005, 01:05 AM
  7. Reduce a value by spliting the data
    By Kev in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2005, 08:14 AM

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