+ Reply to Thread
Results 1 to 6 of 6

[Solved] Use Trimmean Function with multiple cells/arrays

  1. #1
    Registered User
    Join Date
    12-17-2011
    Location
    FL
    MS-Off Ver
    Mac Excel 2011
    Posts
    8

    [Solved] Use Trimmean Function with multiple cells/arrays

    Hi everybody and thank you for this great forum,

    I would like to use the function "trimmean" with several arrays of cells from different location on the same sheet. I would like to know whether it is possible and if not, what do you think would be the alternative?

    Thank you for your help,
    Last edited by Micdis; 03-23-2012 at 11:54 AM.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Use Trimmean Function with multiple cells/arrays

    Hi Micdis,

    Yes... this is possible.

    See the attached file where I have used three data arrays on the same sheet in the TrimMean function. Thanks.


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Attached Files Attached Files
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

  3. #3
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: Use Trimmean Function with multiple cells/arrays

    Please mark this thread as Solved. Check the FAQ's to see how.

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Use Trimmean Function with multiple cells/arrays

    Thanks darknation144... for the heads up..

    Dear Micdis,

    If you are satisfied with the answer kindly marked the thread as solved. Edit your first post and prefix [SOLVED]..

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Registered User
    Join Date
    12-17-2011
    Location
    FL
    MS-Off Ver
    Mac Excel 2011
    Posts
    8

    Re: Use Trimmean Function with multiple cells/arrays

    Completely Satisfied, many thanks!

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: [Solved] Use Trimmean Function with multiple cells/arrays

    You are welcome ... .

    Regards,
    DILIPandey

    <click on below star if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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