+ Reply to Thread
Results 1 to 5 of 5

The same pattern in the "Rows"

  1. #1
    Registered User
    Join Date
    10-31-2019
    Location
    Kenya
    MS-Off Ver
    2010
    Posts
    3

    The same pattern in the "Rows"

    Am trying to stop the occurance of a duplicate pattern happening from 2 values in the Row cells, arranged between 12 collumns (A - L) in an attempt to collate all the posible pattern combinations in the Rows cells. How can i comb for a pattern that has occured more than once?

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: The same pattern in the "Rows"

    Hello Allan muturu. Welcome to the forum.

    This is not very clear.

    Please show us what you mean by uploading an Excel workbook file example. Please make sure it is a workbook file and not a picture/screenshot/copy-paste sample.

    Please show us about 8 to 10 rows of what it is you are trying to "stop" (?) and 8 to 10 rows of desired results.

    If you are not familiar with how to do this ...
    To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

    be sure to desensitize the data

    click “Go Advanced” (next to Post Quick Reply – bottom right),
    scroll down until you see “Manage Attachments”, click that,
    click “Browse”.
    select your file(s)
    click “Upload”
    click “Close window”
    click “Submit Reply”

    The file name will appear at the bottom of your reply.

    (Of note: The 'paperclip' icon has not worked for some time. So please save yourself some grief.)
    Dave

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,336

    Re: The same pattern in the "Rows"

    Please attach the workbook to this thread. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: The same pattern in the "Rows"

    Using the attachment in the thread that was closed. Either:

    Helper in M1:
    =A1&B1&C1&D1&E1&F1&G1&H1&I1&J1&K1&L1

    Formula in N1:
    =COUNTIF($M$1:M1,M1)

    or formula in (e.g.) P1:
    =COUNTIFS(A$1:A1,A1,B$1:B1,B1,C$1:C1,C1,D$1:D1,D1,E$1:E1,E1,F$1:F1,F1,G$1:G1,G1,H$1:H1,H1,I$1:I1,I1,J$1:J1,J1,K$1:K1,K1,L$1:L1,L1)

    in both cases, replicated values will return >=2 and uniques/first occurrences will return 1. there were no replicates, so I created one.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: The same pattern in the "Rows"

    Quote Originally Posted by AliGW View Post
    Please attach the workbook to this thread. Thanks.
    Thanks for the back up Ali. I forgot to mention that detail

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  3. Replies: 35
    Last Post: 01-13-2016, 02:16 AM
  4. regex: include split "0=" like "a=" into .pattern
    By DavidRoger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2014, 01:32 AM
  5. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  6. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  7. Replies: 1
    Last Post: 09-21-2013, 03:18 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