Results 1 to 11 of 11

Count rows down to previous occurrence

Threaded View

  1. #1
    Registered User
    Join Date
    08-29-2013
    Location
    U.S.
    MS-Off Ver
    Excel 2007
    Posts
    4

    Count rows down to previous occurrence

    Hello,
    In this sample, I'm working with 2 sheets and I have inserted notes on what I am trying to do. Sheet1 has 5 columns of numbers and more will be added by inserting a row at row 1. Sheet2 has a set of 3 numbers and I would like a count of rows (in Sheet1) down to the previous occurrence of the set of 3 numbers. The 3 numbers can be in any of the 5 columns but need to be in the same row. The count should start at row 1 and count down but no more than 100 rows. If no occurrences, than I would like the count to be 0. Any help will be Greatly Appreciated! Thank U!
    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. [SOLVED] Count duplicate value in previous rows
    By drnszgy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-04-2013, 08:45 PM
  2. Replies: 3
    Last Post: 03-24-2011, 02:00 AM
  3. Replies: 3
    Last Post: 08-03-2006, 01:58 PM
  4. [SOLVED] Match Last Occurrence of Numeric Value and Count BACK to Previous
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-23-2005, 10:20 PM
  5. [SOLVED] Match Last Occurrence of two numbers and Count to Previous Occurence
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 04-04-2005, 10:06 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