Results 1 to 5 of 5

Trimmean formula or alternative

Threaded View

  1. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,901

    Re: Trimmean formula or alternative

    I get the same results when testing with RANK so hopefully just changing the formula to read as follows in B1 and down will work for you:

    EDIT: In addition I changed % in the formula in B1 and down so that it reads:
    =RANK(E1,E$1:E$10,1)<90.00000000001%*COUNT(E$1:E$10)
    Let me know if you have any questions.
    Last edited by JeteMc; 02-25-2016 at 02:09 PM. Reason: Correcting an error in formula

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Alternative TRIMMEAN
    By Brennen81 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-06-2015, 09:29 AM
  2. [SOLVED] Trimmean in Pivot Table
    By botanybob in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-11-2014, 11:03 AM
  3. [SOLVED] Using TRIMMEAN on a selection of data
    By Krogerstrom in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-05-2013, 06:50 AM
  4. [SOLVED] TRIMMEAN & OFFSET together
    By JTM1200 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-11-2012, 05:23 PM
  5. Replies: 3
    Last Post: 08-15-2010, 09:27 PM
  6. [SOLVED] TRIMMEAN with different percentiles?
    By agbiggs@hotmail.com in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-14-2006, 01:15 PM
  7. Trimmean for limited array
    By Sige in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2006, 12:30 PM

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