+ Reply to Thread
Results 1 to 7 of 7

Computing Decile function on every nth row in a column

  1. #1
    Registered User
    Join Date
    11-16-2020
    Location
    Central Texas
    MS-Off Ver
    Office 2016
    Posts
    8

    Computing Decile function on every nth row in a column

    Hello, I'm working with a large column of data that has "mixed" results in each row. However, every third row contains numbers for which I want to compute the decile function for the entire column. I'm attaching a sample spreadsheet using 150 rows of data with which to perform hopefully the right approach. To the right, I show a "manually" calculated correct performance using the regular decile function. I could use some help with an approach the will calculate the Xth decile on every Nth row in a column. thanks for your help!

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,557

    Re: Computing Decile function on every nth row in a column

    There is no spreadsheet attached to post #1.
    If you attempted to attach a spreadsheet using the paperclip icon it doesn't work.
    Please utilize the instructions in the banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    11-16-2020
    Location
    Central Texas
    MS-Off Ver
    Office 2016
    Posts
    8

    Re: Computing Decile function on every nth row in a column

    Sorry about that. Please see attached.
    Attached Files Attached Files

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,725

    Re: Computing Decile function on every nth row in a column

    If you want to generate those numbers in column F automatically, you can use this formula in cell F11:

    =INDEX(B:B,(ROWS($1:1)-1)*3+5)

    then copy down as far as you need to.

    Hope this helps.

    Pete

  5. #5
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,416

    Re: Computing Decile function on every nth row in a column

    F11 cell formula , Drag down

    HTML Code: 

  6. #6
    Registered User
    Join Date
    11-16-2020
    Location
    Central Texas
    MS-Off Ver
    Office 2016
    Posts
    8

    Re: Computing Decile function on every nth row in a column

    Thank you. I see what is being done. However I'm trying to compute the Decile function on every nth row, without further manipulation of the data. As background, I'm running a monte carlo analysis and capturing 3 kinds of output data with each iteration (using 1000) passes resulting in a column with 3000 rows. Each pass is copied pasted to a separate place. To-date, I've been running macros to "pluck" every nth row item and then using plain excel functions on that fresh column of data. But this is kind of labor-intensive and possibly prone to error. This is why I'm trying to run some kind of modified function to do a regular function on every nth row. Perhaps my sample file led you down this path. Sorry about that. What I'm trying to do is run a decile function on every nth row, where each nth row represents the data I want to compute the decile function on. Is this possible?
    Last edited by TXMcNasty; 12-05-2020 at 09:15 PM.

  7. #7
    Registered User
    Join Date
    11-16-2020
    Location
    Central Texas
    MS-Off Ver
    Office 2016
    Posts
    8

    Re: Computing Decile function on every nth row in a column

    Bumping to see if there are any new answers that may work.

+ 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. [SOLVED] Decile Groupings
    By xygrax in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-15-2020, 03:26 PM
  2. [SOLVED] Computing Ranges from a column of consecutive numbers
    By smertyn206 in forum Excel General
    Replies: 5
    Last Post: 03-15-2020, 05:28 AM
  3. Calculating the 3rd Decile
    By Pointedcoast78 in forum Excel General
    Replies: 3
    Last Post: 08-11-2014, 10:16 AM
  4. Computing with last 252 rows of varying length column
    By stephens in forum Excel General
    Replies: 6
    Last Post: 11-27-2009, 01:50 AM
  5. Decile Reporting function or formula
    By zacksba in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2006, 01:54 AM
  6. [SOLVED] How do I decile a data base, is there a formula that I can use?
    By I_raggs in forum Excel General
    Replies: 1
    Last Post: 05-18-2006, 11:25 AM
  7. Automatically computing column data for plots?
    By Zerex71 in forum Excel General
    Replies: 0
    Last Post: 05-15-2006, 04:15 PM

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