Results 1 to 12 of 12

The fastest way to find first occurrence of fullfilled condition

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,946

    The fastest way to find first occurrence of fullfilled condition

    Hi,

    i have table:

    Screenshot_9.png

    and i want to find the corresponding month where (Sum is > 86 000 zł) + 1 month.

    So condition is fulfilled in month 8, but we have + 1 so the result should be = 9 (month 9).

    What is the fastest solution in VBA to find this occurrence?
    I am working on listobjects.

    Best,
    Jacek
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find the Occurrence and Result of each occurrence
    By suriya0702 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2019, 01:43 PM
  2. [SOLVED] Fastest Find Last Used Row in Worksheet
    By EssoExplJoe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2016, 07:24 PM
  3. How to get Max occurrence with condition
    By navneetvyas in forum Excel General
    Replies: 1
    Last Post: 05-18-2016, 05:42 AM
  4. Find each occurrence in a column and do for each occurrence
    By jfoerch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2014, 12:29 PM
  5. Retun Nth Non-Blank Occurrence of Condition
    By jtfish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2013, 11:26 AM
  6. If condition fullfilled exit sub
    By fatalcore in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2011, 11:35 AM
  7. Replies: 4
    Last Post: 09-24-2009, 09:57 AM

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