+ Reply to Thread
Page 7 of 8 FirstFirst ... 5 6 7 8 LastLast
Results 91 to 105 of 107

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
    10,057

    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,970

    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,970

    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

  5. #95
    Forum Expert
    Join Date
    07-26-2011
    Location
    S R Nagar, Hyderabad, India
    MS-Off Ver
    Excel 2003; 2007
    Posts
    5,048

    Re: Call in the Cavalry - 2017

    Hi, one of my colleague protected an excel file with password and forgot the password, can any one help in cracking the password.
    Click *Add Reputation to say Thank and Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) If you are satisfied

    Regards

    Siva

  6. #96
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    PeeSee(64)=ROUND(4.831^4.831,0)
    Posts
    3,615

    Re: Call in the Cavalry - 2017

    What about rule 11 ?

    no file - no help
    (hope there is no personnal info or any sensitive data)
    Last edited by sandy666; Yesterday at 01:37 AM.
    sandy (NO CAPS)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything

    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking
    Note: English is not my native language
    Keep It Sophisticatedly Simple

  7. #97
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    40,923

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by nflsales View Post
    Hi, one of my colleague protected an excel file with password and forgot the password, can any one help in cracking the password.
    Siva, you should know better than to ask that here
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think some-1 helped you

    Regards
    Ford

  8. #98
    Forum Expert
    Join Date
    07-26-2011
    Location
    S R Nagar, Hyderabad, India
    MS-Off Ver
    Excel 2003; 2007
    Posts
    5,048

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by FDibbins View Post
    Siva, you should know better than to ask that here
    I did not understand what you said

  9. #99
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    40,923

    Re: Call in the Cavalry - 2017

    It is against forum rules to ask for password cracking

  10. #100
    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
    10,057

    Re: Call in the Cavalry - 2017

    Siva - Your post does not comply with Rule 11 of our Forum RULES.

    Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords

  11. #101
    Forum Expert
    Join Date
    07-26-2011
    Location
    S R Nagar, Hyderabad, India
    MS-Off Ver
    Excel 2003; 2007
    Posts
    5,048

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by AliGW View Post
    Siva - Your post does not comply with Rule 11 of our Forum RULES.

    Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords
    I am aware of that, that's why I asked here without attaching the file

  12. #102
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    40,923

    Re: Call in the Cavalry - 2017

    file or no file, we do NOT allow discussions of password breaking, the rules are very clear on that

  13. #103
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    PeeSee(64)=ROUND(4.831^4.831,0)
    Posts
    3,615

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by nflsales View Post
    Hi, one of my colleague protected an excel file with password and forgot the password, can any one help in cracking the password.
    and what we can say?

  14. #104
    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
    10,057

    Re: Call in the Cavalry - 2017

    Quote Originally Posted by nflsales View Post
    I am aware of that, that's why I asked here without attaching the file
    The rule also clearly states:

    Don't post questions regarding breaking or bypassing any security measure.
    @ Sandy:

    and what we can say?
    Nothing, obviously! Any assistance offered would be in serious breach of the forum rules.

  15. #105
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    IXL,BXL,BE,EU,Earth
    MS-Off Ver
    PeeSee(64)=ROUND(4.831^4.831,0)
    Posts
    3,615

    Re: Call in the Cavalry - 2017

    The question was rhetorical

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

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