+ Reply to Thread
Results 1 to 1 of 1

Input percentiles get result and put into another sheet

  1. #1
    Forum Contributor
    Join Date
    11-19-2019
    Location
    Michigan
    MS-Off Ver
    Office 365
    Posts
    546

    Input percentiles get result and put into another sheet

    I am not sure if this is doable but here goes.


    This sample file contains 2 sheets.
    1. Summary - This is where the results will be populated in columns (all highlighted in yellow) :
    -P
    -X
    -AF
    -AN
    -AV
    -BD
    -CV
    -DE

    2. Inverse %tile Cal with 60th - This is a percentile estimator that will calculate the 65th percentile in column H if you input values in columns D (25th percentile), E (50th Percentile), F (75th percentile), G (90th percnetile) from the summary sheet.

    I have given an example using data located in the summary tab between columns K and R, I have entered the 25th, 50th, 75 and 90 to give me a result of 488,116.13 in cell P4.


    MY ASK: Is there a way to take the 25th, 50th,75th and 90th percentile in each of those sections, input them in the inverse %tile with 60th sheet run it through that model, take the results in column H and put it into that section where it came from in the 65th percentile column.

    I hope this makes sense.
    Attached Files Attached Files

+ 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. Copy & paste input data to sheet, copy result back out
    By stuartsjg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-30-2015, 05:25 PM
  2. Replies: 6
    Last Post: 07-17-2014, 03:08 AM
  3. [SOLVED] print result cards automatically from result sheet
    By excellover2212 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 04-25-2014, 05:24 PM
  4. input box problem, cell filtering problem, result display while locking sheet
    By croozin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2013, 08:52 AM
  5. [SOLVED] Input Box type 1, Use result to find row on sheet
    By LiLi1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-23-2012, 01:59 PM
  6. Database sheet need result in input & output
    By hasin in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 05-10-2008, 01:30 PM
  7. [SOLVED] percentiles?-How does excel calculates the percentiles worksheet function?
    By Agnes Goris in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2005, 11:05 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