+ Reply to Thread
Results 1 to 3 of 3

Pattern Recognition of numbers in a table

  1. #1
    Registered User
    Join Date
    02-26-2019
    Location
    Singapore
    MS-Off Ver
    office 2016
    Posts
    2

    Pattern Recognition of numbers in a table

    Hi, Guys, I have the following data (an example is shown here to explain/use for test) the actual data is in over 4000 rows & growing

    43 53 39 40 63 43 12 44
    44 59 49 55 41 35 40 59
    44 59 48 47 41 43 63 46
    37 48 52 47 45 63 41 44
    41 37 53 51 35 55 48 41
    41 37 53 51 35 55 48 50
    41 37 53 51 35 55 48 43
    46 44 47 51 41 49 45 50
    50 47 42 36 50 38 25 47
    41 47 48 44 53 47 37 37
    50 55 52 51 63 43 45 47
    41 43 47 47 50 49 45 43
    47 37 55 36 55 63 41 48
    59 37 43 49 48 51 45 51
    41 39 48 45 63 49 52 55
    41 50 51 48 45 55 57 48
    47 43 47 47 38 49 37 44

    I want to find out if there is any pattern in between rows any sequence of numbers is being repeated after some specific no of rows, this data requires the only comparative analysis in between rows and not Column,

    your help will be highly appreciated Please do note I have some programming background no excel experience or VBA syntax knowledge would appreciate a slight explanation of the coding with an idea how to implement it
    thanks in Advance
    Mobi

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Pattern Recognition of numbers in a table

    Hi awanone and welcome to the forum,

    I don't see any patterns after a few minutes of playing. See my work attached.

    Looking for Patterns.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    02-26-2019
    Location
    Singapore
    MS-Off Ver
    office 2016
    Posts
    2

    Re: Pattern Recognition of numbers in a table

    Thanks, Marvin, for such a prompt reply, perhaps I was not clear enough in what I was looking for, though your approach is excellent But I was not looking for the addition in the Rows or even counting the repetition of a number within the rows, let me explain for example if you see row number 5,6 and 7, the numbers are identical repeating for up to 7 columns in all three rows, the eighth column has different numbers this is the sort of pattern I'm looking for, is there any sequence of numbers which are repeating throughout, or perhaps are repeating intermittently within the rows ( such as after every 5 rows). In other words what I'm trying to do is treat an entire row of eight numbers in its entirety and am trying to see whether this row repeats partially or entirely throughout the sheet, if I have to do this with some programming language I'm looking at multiple passes of different loops on the database which can get very messy quickly, sorry not a good programmer. I apologise for not being thoroughly clear, this is an experiment with multiple sensor data to see whether there is an impact of certain conditions on the behaviour of sensors would appreciate your input

+ 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. Pattern Recognition
    By lennywatson in forum Excel General
    Replies: 1
    Last Post: 08-02-2017, 10:25 AM
  2. Conditional Formatting: Pattern Recognition
    By Joeleol in forum Excel General
    Replies: 2
    Last Post: 06-15-2017, 09:22 AM
  3. Help with pattern recognition
    By micro7311 in forum Excel General
    Replies: 3
    Last Post: 10-09-2016, 06:31 PM
  4. [SOLVED] Formula pattern recognition
    By cjchris in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2013, 12:08 PM
  5. String of characters recognition without a pattern ?
    By Phalanx_ in forum Excel General
    Replies: 3
    Last Post: 04-18-2013, 06:05 PM
  6. String manipulation and pattern recognition
    By TYork in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-17-2010, 08:58 AM
  7. Pattern Recognition in numbers
    By Ahurdle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2008, 08:34 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