+ Reply to Thread
Results 1 to 3 of 3

Expand Algebraic Formula to Column

  1. 01-24-2020, 08:51 PM #1
    sdl2
    sdl2 is offline
    Registered User
    Join Date
    08-12-2014
    Location
    CA
    MS-Off Ver
    2011
    Posts
    73

    Expand Algebraic Formula to Column

    I need to expand simple algebraic patterns into a column. The patters has repeat segment like (AB)*5 which need to be displayed as ABABABABAB.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-25-2020, 08:38 AM #2
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Expand Algebraic Formula to Column

    Maybe :
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by karedog; 01-26-2020 at 01:41 AM.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important
    Reply With QuoteRegister To Reply
  3. 01-25-2020, 12:26 PM #3
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Expand Algebraic Formula to Column

    Another way -- this just seemed to beg to use regular expressions.

    Sucuri wouldn't allow me to put the code in the post...

    B
    C
    D
    E
    F
    G
    H
    I
    J
    2
    Char
    Name
    Width
    Input:
    		 (CAB2C3(AB)2)2
    Total
    3
    A
    		 Home w/ Print
    1.000
    Expand:
    		 CABBCCCABABCABBCCCABAB
    20.040
    4
    B
    		 Offset w/ Print
    1.000
    Pos
    Char
    Name
    Width
    5
    C
    		 Home Blank
    0.755
    1
    C
    		 Home Blank
    0.755
    6
    2
    A
    		 Home w/ Print
    1.000
    7
    3
    B
    		 Offset w/ Print
    1.000
    8
    4
    B
    		 Offset w/ Print
    1.000
    9
    5
    C
    		 Home Blank
    0.755
    10
    6
    C
    		 Home Blank
    0.755
    11
    7
    C
    		 Home Blank
    0.755
    12
    8
    A
    		 Home w/ Print
    1.000
    13
    9
    B
    		 Offset w/ Print
    1.000
    14
    10
    A
    		 Home w/ Print
    1.000
    15
    11
    B
    		 Offset w/ Print
    1.000
    16
    12
    C
    		 Home Blank
    0.755
    17
    13
    A
    		 Home w/ Print
    1.000
    18
    14
    B
    		 Offset w/ Print
    1.000
    19
    15
    B
    		 Offset w/ Print
    1.000
    20
    16
    C
    		 Home Blank
    0.755
    21
    17
    C
    		 Home Blank
    0.755
    22
    18
    C
    		 Home Blank
    0.755
    23
    19
    A
    		 Home w/ Print
    1.000
    24
    20
    B
    		 Offset w/ Print
    1.000
    25
    21
    A
    		 Home w/ Print
    1.000
    26
    22
    B
    		 Offset w/ Print
    1.000
    27
    23
    Attached Files Attached Files
    Last edited by shg; 01-25-2020 at 06:36 PM.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Expand range of offset/indirect formula to expand to entire range
    By bursuc619 in forum Excel General
    Replies: 6
    Last Post: 11-13-2018, 04:54 AM
  2. [SOLVED] SUMIF formula with dynamic column range and then expand the width of SUM range
    By gravythief in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2017, 08:36 AM
  3. [SOLVED] Duplicate/Expand column formula when rows are added?
    By NewYears1978 in forum Excel General
    Replies: 2
    Last Post: 06-14-2016, 02:41 PM
  4. Excel Algebraic Formula Help
    By ejseidman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2013, 06:40 PM
  5. Need to see full value returned by a formula without having to expand column.
    By Textoph in forum Excel General
    Replies: 3
    Last Post: 06-19-2012, 12:16 PM
  6. Algebraic Formula
    By buhwheet in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-09-2010, 07:20 PM
  7. [SOLVED] algebraic formula to calculate "net uniform series" (NUS)
    By Johnny Logan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2005, 10:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1