distribute

  1. staticfluids

    Distribute Number into Several Part (Increment) Based on Other Data (Dynamic Array)

    Hi all, I hope you're doing well. First of all, sorry for bad explanation as my main language is not English. I'm currently using Excel 2021 and trying to experiment with Dynamic Array formula. It's quite helping with my daily Excel use. 2 of my latest question was asking about Dynamic Array...
  2. A

    Distribute elements in matrices of a set number of rows and columns

    Hello everyone, I am trying to write a macro to distribute elements into matrices of defined (by user) number of rows and columns. Consider a raw data like this: And I want to distribute in Matrices of, for example, 12 rows x 8 columns but each Element group must start at the beginning of a...
  3. D

    How to Distribute data from a master tab to team tabs?

    Hello, I'm looking to figure out how I can distribute from a Master tab to a multiple of other tabs within the same workbook. I'm fairly new to Excel, self learning, but for some reason I cannot wrap my head around how to create this. I appreciate any help I can get. Thank you in advance.
  4. C

    Time Value Distribution Automated?

    Hi all, I am new to this so bare with me. Below is the current solution to my predicament, done manually. I would like to automate the distribution column. For this, the numerator is the TVU column, and the denominator is determined via the COUNTIF() function. The issue is that I cannot get...
  5. M

    How to distribute the value with a percentage

    How to distribute the value of 30 with the following Percentage: A 19.6% B 13.5% C 15.7% D 3.2% I want to get the same value of 30 for A,B,C& D
  6. J

    Distribute Cell values as compared to Negative excel values

    Distribute Black text values of excel as compared to Red Text values, In the below example I want to distribute 45+15 = 60 among 1,3,4,5 but the sum of 1,3,4,5 is 66 so it can distribute the values up to 60 It will choose to distribute the values from Max values to Min values, so I want the C...
  7. M

    Looking for a way to distribute left over cash flows over other loans

    Hi, I'm looking for a way to distribute left over cash flows to other loan repayments. At the moment I have a percentage input of the free cash flows to be distributed over 5 different loans. Those free cash flows are annual and the percentages are fixed. At some point in time, 1 of those...
  8. K

    Sequence numbers based on a Limit and Distribute :/

    Hey guys.. This is a bit complex situation i have here. I have a list of numbers that can vary. And there's a LIMIT which can also change. And there's a COUNT. So I want to distribute the Numbers in the first list so that, the Number should Repeat until the COUNT is reached. But it should...
  9. S

    Generating Random Teams While Rotating Players In

    Hi All, I ran into a wall and hope someone can help. I currently have a clunky spreadsheet that will randomly distribute 16 people into 4 teams of 4 for our volleyball games. What I actually need to do is for the spreadsheet to distribute 20 people into 4 teams of 4, and hold the 4 remaining...
  10. aqeelnokia99

    cell value disruption

    <tbody> PO qty avaible qty a 2 4 a 3 b 4 7 b 3 b 5 c 3 3 c 2 d 1 12 d 5 d 6 d 7 </tbody> =========================== Result i want <tbody> PO qty avaible qty Result a 2 4 2 a 3 2 b 4 7 4 b 3 3 b 5 c 3 3 3 c 2 d 1 12 1 d 5 5 d 6 6 d 7...
  11. J

    How to: Proportionally Distribute Remainder

    Hi, I have a budgeting app that is missing a feature, so I need to perform this calculation manually. I would like to have excel do it for me if possible. Is there a way to distribute a remainder proportionally across the separate categories? In the sample below I need to divide 1.26 among the...
  12. F

    Distribution/Allocation of value

    I am looking to distribute an amount over several employees as a bonus. I have a different percentage I would like to give each employee. How would I go about this? For example, I want to distribute $1,000 over 5 employees. TIA!
  13. D

    Cell Distribution

    Hello, Just want to ask if there is an easy way to distribute the data from Column A to Column B, the result will be on Column D&E.
  14. muhammad susanto

    Distribute Data With 2 Columns

    hi all... how to distribute this data below : Excel 2007 32 bit DEF 2data1data2expected result 3707070 418045180 54545 64545 74545 815238152 93838 Sheet: Sheet1 any helps much appreciated... m.susanto
  15. M

    Aligning and Vertically Distributing Buttons

    I am currently working on an excel project for school and I am unable to figure out how to align the form control buttons to the left and then vertically distribute it. I have tried adding the options to the quick ribbon but they are grayed out...
  16. D

    how to use autosave in excel 2016

    Hi, Can anyone tell me how to use autosave with excel 2016. I have an excel file on my pc, and would like to autosave any changes back to the local file system where it lives (not the cloud, or onedrive) every 3 minutes. I need to distribute this file to several people, can I set it up so it...
  17. Qete_ARG

    Distribute amount with staggering and based on priorities

    Hi guys, I am trying to find yout how to solve this but I am not being able to do it. I also searched but I think I am not using the right words on the search box (sorry for my english). I need to distribute an amount between many contracts, filling first the ons with better priorities than the...
  18. S

    Incremental decreases

    Hello guys Please help me with this question. 10000 10% 12500 15000 17500 20000 22500 25000 7% Above I want to distribute percentages incremental, to decrease between 10%-7%. There is one formula for this. Thanks
  19. A

    Distributing Daily Productions on Calender

    Hello everyone, Can this problem be solved by only functions or is it needed to write macro? I want to distribute daily planned production quantities from starting day to deadline. https://pasteboard.co/GOSLoSn.jpg Thank you very much
  20. S

    How to distribute items from different groups throughout a set number of columns??

    Howdy I've been struggling with building a worksheet to help with some work functions, can seem to connect the math with the excel functions. Any help is greatly appreciated. We have several sets of tools identified by color. There are a varying numbers of each colored set of tools. We also...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top