distribute

1. 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.
2. 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...
3. 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
4. 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...
5. 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...
6. 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...
7. 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...
8. 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...
9. 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...
10. 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!
11. 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.
12. 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
13. 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...
14. 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...
15. 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...
16. 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
17. 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
18. 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...
19. Tricky-Need to populate multiple cells with text from file name of photos. Xl2010/Win7

Brief & descriptive as possible. I have formatted the naming of inspection photos in a manner in which contains details to be populated within a spreadsheet pertaining to their location. I'm trying to use a set of code that takes segments of the file name, transfers them into their respective...
20. merge fields across several columns

I have data that looks like this: Column A Column B Column C PT347-02010 Matrix 1901 (empty cell) Matrix 1902 (empty cell) Matrix...

This Week's Hot Topics

Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
• Block certain cells in condition met in cell A
Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
• IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
Hi, Below formula works well, =(INDEX('PRICE LIST'!\$C\$7368:\$C\$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!\$A\$7368:\$A\$7679)*(WORKSHEET!P28='PRICE...
• Match data from 3 columns to return data from the correct 4th column
Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
• VLookup
Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
• Defining a range
Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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.

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

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