Results 1 to 5 of 5

How to quartile based on multiple items and bids

Threaded View

  1. #1
    Registered User
    Join Date
    03-30-2021
    Location
    Dallas, TX
    MS-Off Ver
    Microsoft 365
    Posts
    3

    How to quartile based on multiple items and bids

    Hi. I am wanting to get the 1st and 3rd quartile from a column that has hundreds of unique names.

    Column A has the Item ID, Column B has the Bidder ID, Column C has the price that was placed by each bidder.

    There will be will around 50 bidders and a couple hundred items, so I want to have one formula that I can use in Column D for the 1st quartile and another in Column E for the 3rd quartile. The formula will look at each item and it's corresponding bids and return the 1st and 3rd quartile for only the bids that were submitted for each item.

    Once I have this information returned I will be able to identify any outliers, proceed to identifying the best bid on each item, assign a letter grade to each bid, and provide feedback to the bidder as to how their bid compared to everyone else.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Quartile with Multiple criteria without using Array
    By Siops in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-20-2020, 03:02 PM
  2. Quartile if basen on multiple variable criteria (3-7 out of 100)
    By Amonia in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-07-2019, 10:52 AM
  3. [SOLVED] Quartile/If with multiple selections
    By Uruz713 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-03-2013, 03:33 PM
  4. [SOLVED] Quartile calculation based on certain values
    By dksodhi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2013, 11:59 AM
  5. 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
  6. Replies: 3
    Last Post: 06-01-2012, 02:06 PM
  7. Quartile Across Multiple sheets Given Criteria
    By ben10 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-28-2011, 01:25 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