+ Reply to Thread
Results 1 to 2 of 2

split a number to equal values across cells

  1. #1
    Registered User
    Join Date
    05-22-2020
    Location
    istanbul
    MS-Off Ver
    2019
    Posts
    1

    split a number to equal values across cells

    Hello
    I want to split a number in a particular value series across cells
    Forexample

    340 --> 100 100 100 40
    520 --> 100 100 100 100 100 20

    Since there are many different numbers, it is necessary to write zero after the last value.

    as 520 --> 100 100 100 100 100 20 0 0 0 0 etc

    My file is attached.

    Thanks a lot.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2021
    Posts
    5,983

    Re: split a number to equal values across cells

    Try this in C2:

    =MEDIAN(0,100,$B2*2-SUM($B2:B2))

+ 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] Equally split number across variable number of cells
    By lanser in forum Excel General
    Replies: 2
    Last Post: 01-29-2020, 09:12 AM
  2. values of a few cells to equal a target number
    By StFXmy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2018, 04:39 PM
  3. [SOLVED] Need to split 240 rows into an equal number, but that number may change month to month
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-17-2016, 04:15 PM
  4. [SOLVED] Return all values less than or equal to another number, but in order
    By LittleFry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-03-2014, 07:58 AM
  5. Counting number of values within a date range equal or great to a number
    By diablo_719 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-15-2013, 02:55 PM
  6. [SOLVED] Counting cells in a column to add formulas to that equal number of cells
    By flipjarg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2012, 11:45 AM
  7. Count number of values equal to MAX of a column
    By dauclair in forum Excel General
    Replies: 1
    Last Post: 05-30-2006, 09:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1