Results 1 to 8 of 8

Alternate data in columns A and B (AAAB, AAAB repeat)

Threaded View

  1. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,427

    Re: Alternate data in columns A and B (AAAB, AAAB repeat)

    This might throw a row or two of errors, if the number of values in column A is not an exact multiple of 3. Try it out:


    Formula: copy to clipboard
    =LET(
    A,A2:B10,
    B,ROUNDUP(1.33*ROWS(A),0),
    C,1+MOD(SEQUENCE(B,,0),4),
    D,INT(SEQUENCE(B,,0)/4),
    IF(C=4,INDEX(INDEX(A,,2),1+D),INDEX(INDEX(A,,1),C+3*D)))
    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. Replies: 5
    Last Post: 08-06-2023, 02:18 PM
  2. Alternate data in columns A and B and input to Column D
    By burnleysteve in forum Excel General
    Replies: 13
    Last Post: 12-23-2021, 12:18 PM
  3. [SOLVED] copy data from columns to columns with repeat names and numbers
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-12-2020, 06:41 PM
  4. Replies: 4
    Last Post: 02-12-2017, 10:20 PM
  5. Delete every alternate columns till the last data in the row from column G
    By andywsw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2012, 11:59 PM
  6. [SOLVED] Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec
    By unibaby in forum Excel General
    Replies: 2
    Last Post: 08-24-2005, 12:05 PM
  7. [SOLVED] analysing data from alternate columns using the countif function
    By Juniper in forum Excel General
    Replies: 3
    Last Post: 04-28-2005, 12:06 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