Page 2 of 2 FirstFirst 1 2
Results 11 to 15 of 15

Thread: Split value into new rows, based on other Columns

  1. #11
    Conjurer Bill Szysz's Avatar
    Join Date
    Apr 2016
    Location
    Poznań, Poland Dublin, Ireland
    Posts
    119
    Articles
    0
    Excel Version
    Excel 365


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Check it out.
    Attached Files Attached Files

  2. #12
    Seeker Sagittariu5's Avatar
    Join Date
    Sep 2020
    Posts
    8
    Articles
    0
    Excel Version
    2016
    Thank you Ken

  3. #13
    Seeker Sagittariu5's Avatar
    Join Date
    Sep 2020
    Posts
    8
    Articles
    0
    Excel Version
    2016
    Thank you Ken and looking forward to you help and insight on the matter. Truly appreciative

  4. #14
    Conjurer Bill Szysz's Avatar
    Join Date
    Apr 2016
    Location
    Poznań, Poland Dublin, Ireland
    Posts
    119
    Articles
    0
    Excel Version
    Excel 365
    Sagittarius5, can you tell me what is wrong with my proposal ? (post #11)

  5. #15
    Seeker Sagittariu5's Avatar
    Join Date
    Sep 2020
    Posts
    8
    Articles
    0
    Excel Version
    2016

    Red face

    Hello Bill,

    Apologies, replied using my phone and overlooked your reply (post #11) on the second page.

    Thank you, I believe this solves my problem.
    Please note I adjustment [Rental Fee]/20 -1 to Number.Round([Rental Fee]/20 -1,0), since wanted positive whole number value.

    Kudos

    Also how do I mark this thread as solved?
    Attached Files Attached Files
    Last edited by Sagittariu5; 2020-09-26 at 01:33 AM.

Page 2 of 2 FirstFirst 1 2

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •