minimum

Hi, I'm trying to create a chart that has a long decimal minimum axis value and would like to offset the axis so that only more readable numbers are visible. For example: change something like this |----------|----------|----------| 1.23424 2.23424 3.23424 4.23424 to...

Hi Guys, Do not know if I can ask this here I want to try and do a spread sheet for my retirement. Say I have 20 years left to work and I want to have $100 000 the day I retire. I want to be able to have a sheet where I can see that I am say in the 10th year and that by this time I should...

Hello! I am trying to find a CSE formula (not sure if I need to do this in VBA?) where I can select a range of data in a column based on fixed first cell in the column but the last point is dynamic depending on the user input. For example: <tbody> Column A Column B R1 R2 R3 R4 10...

Hi, I have a grouping and subgrouping of rows in my worksheet and I want to use the minimum value from each group and subgroup and use those values in a report on a separate worksheet using vba. Here's the situation Emp List (Column)__________________________ Salary - Workers __+ Foremen __-...

Hi, I have a grouping and subgrouping of rows in my worksheet and I want to use the minimum value from each group and subgroup and use those values in a report on a separate worksheet using vba. Here's the situation Emp List (Column)__________________________ Salary - Workers __+ Foremen __-...

Hey everyone, I am trying to set up a conditional Minimum formula. On Sheet 1, I have 1000 IDs split into 20 different groups all on one rolling list. So Column A has all of the IDs, Coulmn B has the group name they are in, and Column C has the values of each. On another sheet (Sheet 2) I have...

Hello - I'm trying to calculate a minimum value from column J when data in column E meet one condition (="1") AND data in column I meet one of two conditions (="E" or ="_"). I can calculate the min using the two conditions in column I, but not when I try to incorporate column E. Formula for...

Hi all, this one is starting to do my head in. it was working fine until they decided that there would be a one-to-many relationship in my mapping table. New table: Linked_ID is fed via vlookup, and looks up the ID of the parent ID. It used to lookup the child of the ID (since it was a one to...

I'm relatively new to excel and have been having an issue with some vba in this model i'm working on.... Essentially I want to run 3 goalseeks on the same dynamic variable (L63) and return the minimum value goalseek finds. The following are the procedures for each goalseek: <!--[if gte mso...

Hi I have the following data: <table border="0" cellpadding="0" cellspacing="0" width="745"><colgroup><col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col style="width:48pt" span="6" width="64"> <col...

I have a table with five columns. The first column is dates(months) and then there are four columns of product prices. I want to index the table by date and product and bring back the optimal (minimum) price in the 3 month period including the current month and the previous two months...

Dear, I need to catch a minimum value from a column with same condition. For example. A B C 123 0.5 0.5 123 0.8 0.5 123 0.6 0.5 123 1.0 0.5 124 0.3 0.3 124 0.5 0.3 124 0.6 0.3 124 1.1 0.3 Below example, Same condition: A Value: B I...

Hi :biggrin: , I use countIF, averageIF and sumIF a lot, and I want to do the same with Min and Max (also Mean and Median if possible), how would I do this? :confused: Example: Day Rating Month Year 1 5 Jan 2007 2 3 Jan 2007 3 4 Jan 2007...

I have a mult-column listbox where I'd like 4 items to be selected before it can be accepted. Is it easy, or even possible to limit a multi-select listbox in this way? It would also be great if a minimum number is possible (separate option). Many thanks David

I'm trying to build a simple order entry screen. I have an Item Table with a field representing the minimum qty that can be ordered for each item. In the order entry screen, I have a field to enter the qty the customer orders. I need a code to validate or automatically change the qty ordered...

I'm sure this is either easy or impossible. My level of skill is good with Excel, very low with VBA. I'd like to create a chart, and use a variable or name to flexibly set the minimum and maximum values for the X and/or Y axis. When I try, I get an error message that says "Your entry can not...

I have three columns (H, M, and O) that record the current value of a stock, the maximum value it reached since bought, and the minimum value. I want column M and O (max and min) to update to reflect changes in column H. If column H ever rises higher than column M, I want column M to update to...

Hi there, I have data whereby I would like the sum of the top 10 numbers in a row and the sum of the bottom 10 numbers in a row. I have done this before by adding another row with ranking and then doing an If statement referencing the ranking. I want to do this operation, however, over many...