+ Reply to Thread
Page 9 of 9 FirstFirst ... 7 8 9
Results 121 to 129 of 129

Call in the Cavalry - 2019

  1. #121
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    7,684

    Re: Call in the Cavalry - 2019

    OP would like to have formulas to automate tracking of withdrawals from retirement portfolio while preserving the formulas and set up that are in place in the file attached to post #1.
    I had tried to steer OP towards some formulas that I felt were more efficient, however...
    https://www.excelforum.com/excel-gen...ml#post5184192
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  2. #122
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    XL 2010,2016
    Posts
    11,821

    Re: Call in the Cavalry - 2019

    Anybody have time to fix the autofilter macro?

    https://www.excelforum.com/excel-pro...ter-range.html

  3. #123
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,180

    Re: Call in the Cavalry - 2019

    I can't really help with this one, since my version of Excel does not support slicers. https://www.excelforum.com/excel-pro...ing-dates.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #124
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    9,266

    Re: Call in the Cavalry - 2019

    I don't think I have the skills to really get involved here, but if somebody wanted to take a run at it.

    I think the problem stems from what started out as a formula to capture unique numbers (dates) is now bleeding over into VBA producing text results.

    https://www.excelforum.com/excel-for...mn-values.html

    https://www.excelforum.com/excel-pro...-2-sheets.html
    HTH
    Regards, Jeff

  5. #125
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,660

    Re: Call in the Cavalry - 2019

    My brain isn't working this morning.

    Does someone want to take over? Thinking it'll come down to a nested IF formula.

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

    I recreated the sample (picture) and desired results as well.
    Attached Files Attached Files

  6. #126
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    XL 2010,2016
    Posts
    11,821

    Re: Call in the Cavalry - 2019

    Can someone thing of a formula solution to this problem?

    https://www.excelforum.com/excel-gen...d-columns.html

  7. #127
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    9,266

    Re: Call in the Cavalry - 2019

    Not sure I see this one as achievable in the way the OP wants. Any ideas?

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

  8. #128
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    21,991

    Re: Call in the Cavalry - 2019

    I am beginning to lose the will to live here:

    https://www.excelforum.com/excel-for...-required.html

    Any takers??
    Glenn



  9. #129
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    29,423

    Re: Call in the Cavalry - 2019

    Anyone have a look at this ...

    https://www.excelforum.com/excel-pro...or-method.html

    We've narrowed down the cause of the problem but Iím not strong on combo boxes and their properties.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread
Page 9 of 9 FirstFirst ... 7 8 9

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