+ Reply to Thread
Results 1 to 2 of 2

Quartile Percent

  1. #1
    Registered User
    Join Date
    08-16-2022
    Location
    atlanta ga
    MS-Off Ver
    excel 2021
    Posts
    36

    Quartile Percent

    Hello,
    Ive attached my file.

    How can i quartile my column M into 4. I want a table ot a model that i can change the prices in those quartiles. I dont want it just 4 quartiles distrubedted equally. I want like a model or table that i can chnage for each year and the prices i want in that quartile

    For example i want 4 quartiles

    Prices from 0-9
    9-15
    15-50
    50-100

    How can i do that? Please any help
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Quartile Percent

    No idea what you want. Please amend your sheet. Add some manually calculated results. Explain how you calculated them manually.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ 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] Commission Percent based on Gross Margin Percent Formula
    By canselmi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2019, 07:05 PM
  2. Commission Percent based on Gross Margin Percent Formula
    By canselmi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2019, 01:10 PM
  3. Formula or function to find percent of a percent in a population
    By maldron in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-25-2013, 08:26 PM
  4. Correlation for 1st quartile, 2nd quartile, 3rd quartile, 4th quartile
    By DexterG in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-11-2013, 07:17 AM
  5. Replies: 3
    Last Post: 06-01-2012, 02:06 PM
  6. Graph Actual Percent with Suggested Percent
    By jaytaylor in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-05-2010, 07:09 AM
  7. [SOLVED] Formatting a number to look like a Percent without a percent sign
    By David Iacoponi in forum Excel General
    Replies: 2
    Last Post: 09-15-2005, 02:05 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