Results 1 to 27 of 27

Finding more than one occurrence

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-26-2013
    Location
    Athens, Greece (born and raised in Sydney, Australia)
    MS-Off Ver
    Excel 2010
    Posts
    114

    Finding more than one occurrence

    I have attached a mockup of the below requirement. I hope someone can assist!

    I need to be notified (in column G and H) when there is a second and third occurrence of the same team (located in row J and K). A notification of the value 2 for the second occurrence, 3 for the third.

    The following condition must also be met, i.e. values in rows of columns B,C,D,E,F must be equal.

    In the mockup you will see that all values from B5-F5 down to B18-F18 are equal. So, within this range, you can check from J5-J18 and K5-K18 how many times a team exists. You need to check both J and K for the same team and must start at J5-J18 followed by K5-K18.

    For example J5 = Reading. By checking J5-J18 Reading only exists once. But checking also K5-K18, you will find Reading in K18. So, I would like you to place a 2 in H18. Same applies for other teams in J and K. Any second, third, fourth occurrence found “in” column J should have the notification in column G on the row the occurrence was found. Any second, third, fourth occurrence found “in” column K should have the notification in column H on the row the occurrence was found.

    Note I used fill colour in the mockup to highlight the some examples. Colour is not a requirement.
    Also note that the real excel I need to run this in has close to 700k rows of data.

    Thank you
    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. Finding 1st Occurrence
    By drltr6 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2022, 04:25 PM
  2. [SOLVED] Finding the nth occurrence after a specified position
    By Subtle in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-08-2017, 07:05 AM
  3. [SOLVED] Finding last occurrence of value in row range
    By Gti182 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-19-2017, 10:28 AM
  4. [SOLVED] Finding last occurrence and summing up everything above it.
    By rdperry11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2015, 05:29 AM
  5. Finding second occurrence is not working
    By allanpark in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-06-2014, 02:39 PM
  6. Finding second occurrence. HELP!
    By allanpark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2014, 09:50 PM
  7. [SOLVED] Finding the last occurrence of a value in a list
    By _Josh_ in forum Excel General
    Replies: 9
    Last Post: 11-09-2012, 09:23 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