Results 1 to 4 of 4

Conditional Quartile.INC function

Threaded View

  1. #1
    Registered User
    Join Date
    02-04-2016
    Location
    New Zealand
    MS-Off Ver
    MS Office 2013
    Posts
    2

    Question Conditional Quartile.INC function

    Hi guys,

    Can you help me please? I need your expertise.

    Can I make multiple box plots based on one table? My tables resembles the one below:

    Apple 4
    Orange 2
    Apple 8
    Orange 1
    Apple 2
    Apple 9
    Apple 3

    How do I apply a condition to the QUARTILE.INC() so it picks up the numbers of Apple with Orange, without making another table?

    ::: UPDATE :::

    So the Quartile function is: =QUARTILE.INC(array, quart). I need a formula for "array" to use specific cells correlated to Apple. Still trying...
    Last edited by nzgin; 02-08-2016 at 04:43 AM. Reason: UPDATE

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 08-05-2013, 01:52 PM
  2. 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
  3. Excel 2007 : Quartile If
    By cloud36 in forum Excel General
    Replies: 3
    Last Post: 07-13-2012, 05:37 PM
  4. Replies: 3
    Last Post: 06-01-2012, 02:06 PM
  5. conditional formatting by quartile
    By casdaq in forum Excel General
    Replies: 3
    Last Post: 03-10-2010, 02:43 PM
  6. quartile pie chart
    By Barry Au in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-08-2007, 10:41 AM
  7. Quartile / Quintile Function
    By Greg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-20-2005, 11:06 PM
  8. Quartile Function
    By tika528 in forum Excel General
    Replies: 5
    Last Post: 03-16-2005, 09:25 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