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

Call in the Cavalry - 2018

  1. #91
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - Office 365
    Posts
    8,667

    Re: Call in the Cavalry - 2018

    OP is missing Excel formula features in a recent purchase that includes Office 365. Since I have almost never used the Function Arguments dialogue I couldn't help.

    Anyone?

    https://www.excelforum.com/excel-for...ml#post4953640
    Dave

  2. #92
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    18,600

    Re: Call in the Cavalry - 2018

    It works on my test sheet, but not on the his supplied sheet (complete with merged cells and a colour scheme to drive you mental):

    https://www.excelforum.com/excel-for...l-columns.html

    Counting DISTINCT values in multiple non-contiguous ranges. I get integers as the result on my sheet, but on his (which has a horrendous link to external data) I get a non-integer result. Going boggle-eyed. Any ideas?
    Glenn



  3. #93
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    19,799

    Re: Call in the Cavalry - 2018

    Anyone know anything about data tables (TABLE as an array)?

    This one has me stumped: https://www.excelforum.com/excel-gen...t-working.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  4. #94
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    2013, Office 365 ProPlus
    Posts
    2,962

    Re: Call in the Cavalry - 2018

    woops replied to wrong thread...
    Last edited by CK76; 08-28-2018 at 09:27 AM.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  5. #95
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    13,779

    Re: Call in the Cavalry - 2018

    Any Ideas on this Mac VBA problem?

    https://www.excelforum.com/excel-pro...h-problem.html
    One test is worth a thousand opinions.
    Click the * below to say thanks.

  6. #96
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office Professionsl Plus 2016- work; 2012 for Mac at home
    Posts
    4,256

    Re: Call in the Cavalry - 2018

    I hate to post this one because I feel like I should be able to solve it (and I suspect I'll do a face-palm when I see what solves it).
    but here https://www.excelforum.com/excel-gen...ket-share.html
    So the OP wants the "adjusted share" values in col D to be adjusted in col E in order for col E to add to 100% BUT ONLY if you do not adjust the values that are in col D that are at 0.50%.
    So essentially he wants E5:E8 to adjust so that all of E5:E14 sums to 100%.
    What I proposed hit the 100% but it also adjusted the values in E9:E14 to less than 0.50% which he wants locked in.
    So you might think it should proportionally distribute the first four values among the remaining 97% but that gets me close but I'm still off .05%.
    And I expect that the formula has to account for a varying # of companies.
    I'll be looking forward to what is proposed as my brain is fried dealing with work and different attempts at this solution.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam C

  7. #97
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    9,765

    Re: Call in the Cavalry - 2018

    I think Get and Transform is the way to handle this one: https://www.excelforum.com/excel-pro...-cvs-cell.html but the OP is skeptical. Anyone with more familiarity with Get and Transform either back me up (or shoot me down)?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  8. #98
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    9,765

    Re: Call in the Cavalry - 2018

    Conditional formatting in Excel 2011 for Mac -- I guess it is not the same as the Windows versions. https://www.excelforum.com/excel-for...ml#post4973743 Can anyone more familiar with the Mac environment help?

  9. #99
    Forum Guru
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    XP - 2007 & Win10 - Office 365
    Posts
    8,667

    Re: Call in the Cavalry - 2018

    Strange invisible "character" in a text import file. Fields in the same row following the offending field advance to the next row upon import into Excel. CODE/MID doesn't show anything, but arrowing through the field in Notepad indicates something is there.

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

  10. #100
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    4,056

    Re: Call in the Cavalry - 2018

    The OP wants to sort based on two columns (date and time). We cannot seem to communicate clearly.

    Maybe I am missing something.

    Too frustrated to continue here:
    https://www.excelforum.com/excel-gen...en-time-2.html

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

    Re: Call in the Cavalry - 2018

    63, I think we all know that feeling really well! Cudo's to you for "walking away" and asking for help, rather than just leaving the OP hanging - thank you for that
    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 someone helped you

    Regards
    Ford

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

  12. #102
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    4,056

    Re: Call in the Cavalry - 2018

    Of course. Although I'm afraid that you just caught yourself in the whirlpool. Good luck!

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

    Re: Call in the Cavalry - 2018

    haha hopefully not. It is amazing how 2 people can explain the exact same thing to the same person - OP cant understand the 1st person, but can understand the 2nd. Seen that so many times before, and have been both the 1st and 2nd person

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

    Re: Call in the Cavalry - 2018

    OK, I have a strange 1 here. OP is trying to mark a thread SOLVED, and shared a screen shot of the top of their window.
    https://www.excelforum.com/excel-cha...n-a-range.html
    post #6.

    It looks nothing like what I see, I thought maybe they were not logged in, but they are. Im now waiting for an answer to see what device they are using.

    Anyone else seen these headings/options?

  15. #105
    Forum Guru davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    XL 2010,2016
    Posts
    11,195

    Re: Call in the Cavalry - 2018

    That does appear to be the headings when "What's new" is selected, not sure how the OP was able to have it selected inside the thread.

    EDIT:Now that I look at it closer, the OP was not in the thread.
    Last edited by davesexcel; 09-19-2018 at 05:08 PM.

+ 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