+ Reply to Thread
Results 1 to 4 of 4

The spread of identical consecutive values in an array

  1. #1
    Registered User
    Join Date
    11-05-2017
    Location
    minsk
    MS-Off Ver
    2013
    Posts
    16

    The spread of identical consecutive values in an array

    HELLO!
    I NEED FROM A TABLE GET B TABLE
    COULD YOU HELP ME?

    IndexID IndexID
    1 1 1 1
    2 2 2 2
    3 3 3 3
    4 4 4 4
    5 5 5 5
    6 65 6 65
    7 65 7 6
    8 65 8 10
    9 6 9 11
    10 10 10 65
    11 11 11 16
    12 12 12 17
    13 13 13 18
    14 13 14 65
    15 13 15 12
    16 16 16 13
    17 17 17 19
    18 18 18 20
    19 19 19 21
    20 20 20 13
    21 21 21 22
    22 22 22 13

    А B


    There is an example in atachments
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: The spread of identical consecutive values in an array

    Hello Anton84,
    You attached a file and this is wonderful but can you give more details how to prepare Table B ???
    PCI
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    11-05-2017
    Location
    minsk
    MS-Off Ver
    2013
    Posts
    16

    Re: The spread of identical consecutive values in an array

    surely PCI!

    I need to insert between the same consecutive values (id) the following three values(id), different from them

    And then I need again to numerate my digital array by index
    Last edited by Anton84; 07-21-2018 at 10:11 AM.

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: The spread of identical consecutive values in an array

    the following three values(id)
    Why after the second 65 is coming 16,17,18 and not 12, 16, 17 ???

+ 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. [SOLVED] Check for 5 consecutive identical values
    By mychael14 in forum Excel General
    Replies: 11
    Last Post: 03-25-2016, 11:45 PM
  2. [SOLVED] Numbering consecutive identical cells in a column
    By boomcie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2015, 07:54 AM
  3. Replies: 1
    Last Post: 09-11-2012, 05:43 PM
  4. [SOLVED] Count consecutive non-zero values; list first non-zero value; display counts as an array
    By treznick in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-17-2012, 08:25 PM
  5. Is there a shorthand for listing many consecutive values in an array?
    By fbarbie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-01-2005, 10:47 AM
  6. finding consecutive values in array
    By upstate_steve in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-11-2005, 03:37 PM
  7. finding consecutive values in array
    By upstate_steve in forum Excel General
    Replies: 0
    Last Post: 01-11-2005, 01:03 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