a1a4

  1. E

    Redistribute Values Formula Advice

    Hello, I am looking for advice with a mathematics formula. Say in Cells A1:A4 i have the below 4 percentage values: A1 - 45% A2 - 25% A3 - 20% A4 - 10% Total - 100% I am looking to set up a formula in cells B1:B4 that if i change one of those % values in A1:A4 that the changed value be...
  2. P

    50 sets of data in sheet1 , need to create 50 new sheets and pull in 1 set of data for each

    Hello Are there formulas that could be placed in Sheet2-4 to pull in data from sheet1 all at once? This example shows 3 sheets, but in reality I have 50 sets of data in sheet1 and would need 50 separate sheets populated Data Sheet1 - A1:A3 Set1 Set2 Set3 Bob Tom...
  3. T

    Solver with Data Validation "List"

    Is it possible to have solver solve subject to the constraint of using a data validation list? Better explanation is that I have used the data validation 'list' function for cells B1:B9, of which a value can be picked from a source input into cells A1:A4. I would like to be able to solve for...

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