+ Reply to Thread
Page 7 of 7 FirstFirst ... 5 6 7
Results 91 to 94 of 94

Call in the Cavalry - 2017

  1. #91
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2010 (Win 7 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    9,942

    Re: Call in the Cavalry - 2017

    I think this one probably needs a VBA solution to rearrange the data. Can anyone help?

    https://www.excelforum.com/excel-pro...f-columns.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  2. #92
    Forum Expert
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - 2013
    Posts
    5,963

    Re: Call in the Cavalry - 2017

    If this is doable by formula it is above my head.

    Maybe VBA?

    https://www.excelforum.com/excel-gen...ml#post4718186
    Dave

  3. #93
    Forum Expert
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3,826

    Re: Call in the Cavalry - 2017

    In Post #5 of this thread the OP would like to calculate the 95th percentile of the data (194000 rows) using the LOGINV function.
    The problem as far as I can tell is the presence of #NUM errors in the data, E15671:E19044 (among other places), however I may be missing something and feel that there may be others that are more well versed in statistical analysis that could offer help.

    https://www.excelforum.com/excel-for...ml#post4720083
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  4. #94
    Forum Expert
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - 2013
    Posts
    5,963

    Re: Call in the Cavalry - 2017

    Anyone familiar with finance?
    OP is struggling with an Averaging goal in a field I am not familiar with. I sense attempt to average averages. All I could solve was the array error. After that I don't even know what the questions are.

    https://www.excelforum.com/excel-gen...ml#post4724386

+ Reply to Thread
Page 7 of 7 FirstFirst ... 5 6 7

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1