+ Reply to Thread
Page 11 of 11 FirstFirst ... 9 10 11
Results 151 to 155 of 155

Call in the Cavalry - 2018

  1. #151
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    9,591

    Re: Call in the Cavalry - 2018

    OP is attempting to apply TREND/FORECAST to an attendance tracking mission. I know how those functions work. I do not always know how to apply them in sound ways.

    Anyone want to take a crack at this?

    Attempting to Predict Future Employee Attendance Occurrences

    In case it helps the thread also contains a link back to another thread where this all started.
    Dave

  2. #152
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    10,326

    Re: Call in the Cavalry - 2018

    The OP here is either not understanding my proposed lookup approach or something, but seems inclined to have a long nested IF() instead https://www.excelforum.com/excel-for...nested-if.html Anyone care to take a crack at the nested IF() logic?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #153
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    20,566

    Re: Call in the Cavalry - 2018

    Quote Originally Posted by MrShorty View Post
    The OP here is either not understanding my proposed lookup approach or something, but seems inclined to have a long nested IF() instead https://www.excelforum.com/excel-for...nested-if.html Anyone care to take a crack at the nested IF() logic?
    I gave him a table-free solution, but I betcha it's not acceptable either. Nested formulae do my head in... way too many brackets to get in the wrong place!!
    Glenn



  4. #154
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    Excel 2007
    Posts
    5,140

    Re: Call in the Cavalry - 2018

    Regarding this thread. https://www.excelforum.com/excel-pro...ml#post5035913
    I offered OP a working solution but as a follow-up question he mentions Chinese signs in some of the filenames and code debugs on that.
    Anyone has experience with Chinese signs in filenames ?
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

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

    Re: Call in the Cavalry - 2018

    Call in the Cavalry - 2019 thread here:

    https://www.excelforum.com/the-water...ry-2019-a.html

+ Reply to Thread
Page 11 of 11 FirstFirst ... 9 10 11

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