Results 1 to 19 of 19

Excel Recursive function or not..! Pl help

Threaded View

  1. #8
    Forum Contributor
    Join Date
    12-22-2010
    Location
    Rio, Brazil
    MS-Off Ver
    Excel 2010, 2016
    Posts
    209

    Re: Excel Recursive function or not..! Pl help

    Thanks! It works for all cases except...[LIST] starting hole is not 1 and 9/18 is 9. In the table, rows 6,8,9

    17 - 9 - 7 (17+9-1-18 = 7)
    18 - 9 - 8 (18+9-1 = 8)
    10 - 9 - 18 (10+9-1 = 18)

    Basically, we need to recount starting from 1, after the summation goes over 18, if not remain as is.
    I subtract 1 just to include the starting hole or its over by 1 all the time.
    Re thinking
    Last edited by mlcb; 09-12-2013 at 02:27 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Some One Help me write Recursive function on my Code
    By jatin89 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2013, 07:40 PM
  2. Recursive function that updates columns
    By lundy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2012, 04:25 PM
  3. writing a recursive function
    By rmoney in forum Excel General
    Replies: 6
    Last Post: 07-19-2010, 02:59 PM
  4. Recursive/Running Function
    By goldm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2009, 08:34 AM
  5. [SOLVED] close workbook without closing excel and stop recursive function
    By chris in forum Excel General
    Replies: 3
    Last Post: 07-10-2006, 03:29 PM

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