+ Reply to Thread
Results 1 to 4 of 4

Mode Function??

  1. 05-23-2005, 03:42 PM #1
    november678x
    november678x is offline
    Registered User
    Join Date
    05-23-2005
    Posts
    13

    Question Mode Function??

    Hello, does anyone have formula that can show me the high and low grades for a time period?

    Example

    1st Qtr
    A-

    2nd Qtr
    B

    3rd Qtr
    C-

    4th Qtr
    B-

    5th Qtr
    A

    Formula should calculate 5 Qtr High=A, and another formula in a different column should calculate Five Qtr Low=C-

    Thank you
    Reply With QuoteRegister To Reply
  2. 05-23-2005, 06:32 PM #2
    olasa
    olasa is offline
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    Something like this (see encl. zip-file)?
    =INDEX(C3:C8;SMALL(IF(COUNTIF(A3:A16;C3:C8)>0;ROW(INDIRECT("1:"&ROWS(C3:C8))));1))

    Hope it helped
    Ola Sandström
    Attached Files Attached Files
    Last edited by olasa; 05-23-2005 at 07:00 PM.
    Reply With QuoteRegister To Reply
  3. 05-24-2005, 04:38 PM #3
    november678x
    november678x is offline
    Registered User
    Join Date
    05-23-2005
    Posts
    13
    Looks great! This is exactly what I am looking for. Thank you
    Reply With QuoteRegister To Reply
  4. 05-24-2005, 06:32 PM #4
    olasa
    olasa is offline
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    Happy it was what you needed
    Thanks for the feedback.
    Ola Sandström
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1