+ Reply to Thread
Results 1 to 2 of 2

How to Identify patterns in worksheet?

  1. #1
    Registered User
    Join Date
    05-02-2011
    Location
    MA, USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    How to Identify patterns in worksheet?

    I'm not sure how to phrase this exactly so it's making it hard for me to search for the answer. I'm trying to analyze sports data and what I want Excel to do is to find a pattern, stop when it gets to a certain conditioin, then give me data three rows below it. If my spreadsheet read:

    A B C
    1 Reds W:13-2
    2 Reds L:1-6
    3 Reds W:10-8
    4 Cardinals L:2-8
    5 Cardinals W:13-8
    6 Cardinals L:5-15
    7 Giants L:2-5
    8 Giants L:3-5
    9 Giants W:6-5
    10 Phillies W:4-0
    11 Phillies W:7-5
    12 Phillies L:4-8
    13 Cubs W:11-2
    14 Cubs L:2-4
    15 Cubs L:3-5
    16 Cubs W:4-3


    I want Excel to see the three "L:" in column C, stop when a blank rowcomes up, skip down three rows, then give me the value in column A. In this example, Excel sees c6,c7,c8 and the blank c9. Skips rows 10,11,12, and gives me the value of A13. If C13 doesn't contain "L:" then it will give me the value of A14. I would like for this to work with both "L:" and "W:" and for the patterns to not overlap. Is this possible? Is what I'm asking for even make sense? Thanks in advance.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,156

    Re: How to Identify patterns in worksheet?

    Is what I'm asking for even make sense?
    Sorry, not to me. It seems as though a few people have looked at your post and not responded.

    It may help others to help you if you posted a sample workbook with before and after scenarios explaining, step by step, how the result(s) is(are) achieved.

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

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