+ Reply to Thread
Results 1 to 4 of 4

Find and add numbers corresponding to a delimiter position

  1. #1
    Registered User
    Join Date
    03-28-2022
    Location
    Australia
    MS-Off Ver
    Home and Student 2019
    Posts
    5

    Find and add numbers corresponding to a delimiter position

    G'day,

    Back again after last time you guys were so helpful.

    Everything is the same for each corresponding item (RP Laid, SP Completed, RP Retrieved and RP Harvested) so for simplicity I will just talk about the SP Completed.

    Overall Goal:
    To calculate the total SP completed from the numbers manually entered into the bottom section and show this calculated number in the top R/H section depending on the line number used.
    I am trying to keep everything on one line, hence my question if i can use a delimiter to separate information.


    Example.

    For SP Completed the following information would be entered:
    day 1, line 1 had 100, line 2 had 200
    day 2, line 1 had 100, line 2 had 200
    day 3, line 3 had 500.

    Now in the upper R/H section I would like this table to be filled in automatically by adding the numbers corresponding to that line number.
    So in the upper R/H section, under line 1, for SP completed i would like it to show 200,
    the same for line 2, showing 400, and 500 for line 3.


    So i somehow need the cell AN5 to search for the information contained in cell AN2 (line number), within cell D14, then find the position in regards to the comma and add the numbers from cell E-H14 at the equivalent comma position.

    I think this is maybe a bit complicated so i am also open to other ideas, but i would like it to stay on one line if possible.

    Looking forward to what you guys come up with.


    Thanks,

    Jim.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,001

    Re: Find and add numbers corresponding to a delimiter position

    First remove merged cells ! Not needed and are source of problems. You reference to E-H14 illustrates this as the cell reference is E14 only.

    And column E needs to be TEXT if you have comma delimeters

    Please Login or Register  to view this content.
    in AN5

    =RPLaid(AN$2)

    Copy across
    Last edited by JohnTopley; 06-21-2022 at 09:46 AM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    03-28-2022
    Location
    Australia
    MS-Off Ver
    Home and Student 2019
    Posts
    5

    Re: Find and add numbers corresponding to a delimiter position

    Thanks John!

    That is great, possibilities are amazing.

    Is their a way I can make the table refresh automatically without having to click on each cell and press enter on the formula?

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,001

    Re: Find and add numbers corresponding to a delimiter position

    Added code to "Sheet1" so if data is entered in E14:E23 then AN5:AP5 is updated.

    Righ_click on "Sheet1",, "View Code" and Cop/paste into blank area

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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: 10
    Last Post: 09-17-2021, 05:36 PM
  2. separate the numbers from the 4th position to the 12th position.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2020, 04:58 PM
  3. [SOLVED] Find position 2 double numbers
    By Berna11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-01-2019, 11:40 AM
  4. [SOLVED] formula to find starting position and count numbers in a string
    By craig04 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-07-2017, 03:33 PM
  5. [SOLVED] Take cell value spit on delimiter SORT the ensuing array then Join on delimiter post back
    By capson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-05-2016, 03:54 PM
  6. Replies: 10
    Last Post: 07-09-2014, 05:44 PM
  7. Split Text using numbers as Delimiter.
    By ksalsaadi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-26-2012, 12:42 AM

Tags for this Thread

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