distribute

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...

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...

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.

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...

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

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...

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...

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...

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...

<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...

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...

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!

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.

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

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...

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...

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...

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

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

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...