weight

  1. M

    Macro to change all line weights of all series in all charts in one worksheet

    Hello Excel gurus, I've a sheet with more than 50 graphs. I just want to change all series lines weight to 1. I've written some code but (as usual) it did not work. do you have any better idea or can you correct my code for it to work? Thank you very much! Kevin Sub Change_all_charts()...
  2. L

    Weight decimal as ounces rather than fractions

    I have a range of cells that is populated with weight amounts and an adjacent column with its pricing for shipping, for example: <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> 0.1 $0.75 0.3 $1 0.4 $1.15 0.6 $1.5 0.12 $2 0.14...
  3. F

    Trying to track weight loss over 8 cells in the same row with the last cell showing the weight gain or loss

    i have a formula that works for 3 weight entries {=IF($AP5="",$AG5-$Y5,$AP5-$Y5)} Y= first weight entry, AG5= second weight entry and AP5= third weight entry. I am not sure how to expand it to figure weight gain or loss for seven entries. All help is always appreciated.:beerchug:
  4. andrewb90

    Averaging with weighted numbers

    Hello, I have a set of number I am trying to average, but am having a problem. In cells c6:c10 I have numbers (130 in this case) in cell c4 I also have 130, in c5 I have 4. c5 represents that the 130 from c4 is an average of 4 numbers. What I am trying to get is the average of all the...
  5. F

    Weighted Average (I think!)

    Help! I am trying to compile a return on investment (ROI) workbook for my business, which contains four subsequent departments. When I calculate my ROI for the whole organization I get one number, then when I break it down by each of the four departments and then compile those four ROI numbers...
  6. B

    How to create a formula for weighing and summing an undefined number of rows?

    Hello, I am looking for help to crack this one: I want to calculate the total discount to customers based on discounts on individual products. However the number of products vary from each customer. How can I do this fast and automatic in excel? (And I am stuck with a column in between the two...
  7. N

    Using Excel to determine which row to choose

    Hello Excel experts out there, I have multiple rows of data with same batch number & different end dates. I want to be able to use Excel assign a weight to the row base on the latest end date. After that, I want to pivot the data base on the weight assigned to it. Pls see below for example...
  8. R

    Only be able to write in a cell if another has content in it... PLEASE HELP

    Hey, I'm creating a BMI calculator in MS Excel 2010. I worked out the formula for calculating the BMI... but my problem now is: There is a cell in which the user can write a target BMI (what they want to achieve). What I want is that the user should only be allowed to write in that cell if...
  9. B

    Imperial Weights in charts

    This has me confused! I have a sheet with a column of dates and a column of imperial weights that look like "10st 6lb". I need to chart the weights but cant seem to do it. I converted the cell into something I thought Excel would understand by using the following...

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