1. E

    Maximum possible allocation given constraints

    Hey Guys, I'm not too sure how to approach this but i think it's a VBA problem and i'm having a lot of trouble figuring it out. Apologies in advance... it's a long one lol TL;DR The problem is i'm trying to find the optimal allocations to result in the highest possible value given some...
  2. W

    weight on a bar denomination calculator

    I have created the following : <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> Total weight 45 25 15 10 5 220 4 1 1 0 0 100...
  3. S

    Weight Loss Spreadsheet: Tracking new Weight Loss Records

    Hi wonderful people, I'm working on a spreadsheet for a weight loss program where a participant receives a financial reward for every full pound of weight they lose. Not sure if that title is exactly what I'm looking for, but it was a struggle to describe it in a few short words. I am...
  4. S

    Order of operations

    Hi all, I was wondering if anyone could help me confirm that this formula, =60.7*height+45.3*weight-2055, was correctly written with the order of operations when put into excel. A2=(60.7*B2)+(45.3*C2)-2055 B2 = height C2 = weight Thanks in advance.
  5. H

    Count in a Col depending on another column?

    Hi Folks Having a brain fart...... On my "counts" sheet I want to get the number from a column in my KCPs sheet but only to be counted if cells another column in KCPs contains a specific value (T1)..... I thought this =COUNTIFS(KCPs!$H$2:$H$10000,"T1",KCPs!$K2:$K10000,<>"") (My K column is...
  6. J

    UDF returning an Error

    Hi, When I am passing a range to the below UDF, say A1=CorrelationCoefficient(B1:C100, 1, 2, 0) I am getting an VALUE error. Any reason why? The code is: Public Function CorrelationCoefficient(MyArray() As Double, Optional asX As Long = -1, _ Optional...
  7. S

    A question of aggregation...

    Hi all Long time lurker, first of many posts hopefully... I have a table in power bi with 2 columns. Column 1 = type of animal. Dog, cat, hamster, mouse, etc. Column 2 = weight of animal. Integer value. I have a bar chart with the x axis = type of animal. Each bar is the average weight of...
  8. M

    Find data in table

    I am currently trying to work out how to return a row label based on the position of a value found in a table. My table has 4 rows and 7 columns of data (plus a row and column of labels). I want Excel to find my formula's value in the table and return the label for that row. This is to do with...
  9. M

    Minimum acceptable value with solver

    Hello! I'm using solver for stock portfolio optimization. The solver changes weights to achieve maximum expected return. I have set the following constraints: The portfolio should consist of at least 5 stocks (out of 10) and maximum weight assigned for one stock is 30%. In this case the solver...
  10. S

    Calculating running time from weight of footwear

    Hello, I'm trying to make a table or chart which can show how much a person's running time will change with different weights of footwear. Ideally, I'd like to be able to enter a theoretical weight (in g or kg) and come up with a time in mm:ss or even just straight seconds. An example: A...
  11. G

    Returning Value from range array

    Hello, I'm looking to inquire about how to return a country's cost, based on a given weight. The issue is that the weights I'm looking up against have predesignated weight breaks, the given weights ('B' below) may fall between the range. I'm ultimately looking to return the rounded up value...
  12. L

    State Level Dynamic Count

    Hello, I will do my best to explain what I am looking to do. 1) Column A has a person's name 2) The top columns have all 50 states 3) The states that the people have licenses in will have an "x" in them. So it would look something like this <tbody> CA AZ FL OR NV Betty Sue X X X...
  13. G

    Variable start date pivot table or anothe roption?

    Hi, Have a data set with 6 columns and roughly 10000K rows. My columns are: Date/Initials/Commidity/Weight/Container Weight/Net Weight. I use this data to track how much recycling material is processed with 4 different types of commidities. However, while this is used for every entry, once my...
  14. I

    Formula for MOD 10 Weight 2 Algorithm

    I am looking for an xl formula to calculate the check digit for a MERS MIN. They tell me it is a MOD 10 Weight 2 Algorithm.
  15. T

    UDF not recalculating

    Hi All, I have a UDF that works fine until I make an edit in another workbook. On return to the workbook with the UDF, it is not calculating properly. A press of F9 will force correct calculation. I have the line Application.volatile at the start of the function. If I edit any cell in the...
  16. P

    Positive/Negative Addition

    I am trying to make a chart to figure weight lost gains and losses per person. I need the beginning weight for the month with week 1's weight, week 2 and so on. I also need, in between the weeks, the gain or loss amount which I have figured by subtracting the two. When I get to the end of the...
  17. R

    How to find weight value measured on the nearest date to another date?

    <tbody> A B C D E F G H I J 1 ID DATE1 WEIGHT1 DATE2 WEIGHT2 DATE3 WEIGHT3 DATE4 WEIGHT4 ARRIVAL DATE 2 12345678 43108.55 60 39681.38 62 38227.88 58 42507.28 61 41109.58 3 23456781 42509.9 100 42634.77 111...
  18. DataBlake

    Shipping Calculator

    Hello, I have an issue where i have a shipping chart and want to use vlookup on the weight to grab a shipping price. the only thing is that anything past 150 lbs will be charged $0.47 per pound thats over 150. So lets say a have the weight in row B. B2 = 200. If B2 > 150 it needs to grab the...
  19. E

    Matrix Lookup (finding a match using two criterion)

    Hi Team, Would you please help me develop an index match or some type of lookup formula that has the following: Lookup table looks like this <colgroup><col span="4"><col><col></colgroup><tbody> Code Start Weight End Weight A B C D 0.00 0.8 $5.08 $5.55 $5.13 $5.17 0.81 0.9 $5.11 $5.58...
  20. C

    Formula with multiple IF's?

    Hi There, I need to do a simple calculation between 2 cells in a table. Column headers are "Weight in" and "Weight out" I simply need to deduct weight out from weight in and only want this calculation to be applied when both cells contain value and weight out is less than weight in . Thanks Dan

Some videos you may like

This Week's Hot Topics