min

Hi Firstly, I need to achieve the following within PowerQuery (shockingly my employer still uses Office 2010) and not a fan of PowerPivot in 2010 (too easy to break the model!). In my PowerQuery I will be providing various rankings for based upon multiple conditional columns, what I then need...

Hello, I have the below formula used to calculate a charge after a certain amount of days (7), However it is not calculating the charge correctly, it goes to the min charge of $50.00 only for the first 5 days. If the Volume is larger it should calculate the past the min charge. It seems to work...

I pulled the results from analysis software Now I need to sort the results like that for every beam name like (GB58,GB59,GB60.....) at Column "B" I want to show only the maximum and minimum value at Column "D" I want to delete all values between the max and min for every beam name...

Can anybody tell me how to copy cell data at specified date and time ? I am having auto updating every 15 min sheet of stock market price. I want to save data every 15 min to a predefined cell.for one day. Thanks in advance

I have data of few months. <colgroup><col><col span="2"></colgroup><tbody> Date Name Value 01-04-2018 a 2 03-04-2018 b 2 05-04-2018 c 8 07-04-2018 d 3 09-04-2018 e 1 11-04-2018 f 3 13-04-2018 g 10 15-04-2018 h 9 17-04-2018 i 5 19-04-2018 j 7 21-04-2018 k 4 23-04-2018 l 5...

I'm trying to develop an excel spreadsheet to use for writing work schedules. The current set-up I have is columns A, B, and C are "employee", "status", and "hours",respectively. Off to the side (columns K, L, M) I have a table that designates the range of hours allowed to each employment...

So I have a spreadsheet doing several things, but here is what I'm stuck on. In column H {min #} if it is blank (or I can have the person put a 0), I need it to copy the number that is in the corresponding cell from column J {max #}. So say for row 7 american white pelican it is blank {min #}...

I am looking to find the Min date from 3 cells that are not a range. I thought to use MIN, however, there are cases where the at least one of the 3 cells are blank. Example: =MIN(J23,I97,I78) Cells J23, I97, I78 are all populated by formulas which can sometimes have a blank ("") results. My...

I am trying to create two macros and would really appreciate some help on this, as not sure where to begin. 1. AutoSum Min on first execute then AutoSum Max on second execute (if the macro is executed in the same cell). Then beyond the second execute, the macro should cycle through these two...

Hello friends, I would like create a max and min formula that would also meet some criteria. Column A is for Date Column E is for Price Cell N5 is period start date Cell N6 is period end date I would like to know max and min price within the period. The formula which i used was...

Hi all, I'm struggling for a quite while trying to create formula that split monthly equally cost based on min & max dates from a range. Image of my table can be found below: https://imgur.com/a/6lfa9D7 The idea is spread row values among the min & max dates of red square Any help will be...

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.

Hello! In Excel I want a list of descriptives on multiple columns of a table in the data model. One row for each table column with four columns: column name, value count, min and max values. The data table columns are of different types: text, number and timestamps. Rows are filtered by another...

Evening all Attempting to modify this script which highlights minimum values in columns 2 to 10 & rows indicated in the "RW" array The modification would highlight the 3 minimum values within the row ranges. Thank you guys... Dim Rng As Range, r As Double, Col As Long, Rw As Variant, n As...

Hello Everyone, Does anyone know of a way to turn multiple Columns into one column. For example, I am looking to have one column with 20/40, 30/50, 40/70 and 100M. Then the other columns will contain Avg LT, Replenish LT etc. Please note this is actually 95 total columns with multiple...

Hello. I have a code to find min and max dates in Range("A") and Range("A2") and a MsgBox displaying min date(in format number) and another MsgBox displaying min date (in format number). This is my code and works fine: Sub minmaxdate() Dim rng As Range Dim ws As Worksheet Dim ch As...

Hello, Is it possible to calculate the min value of an input cell that its value is used to other functions, so that a different cell that contains the output of those functions has a specific value? Thanks!

Im struggeling with a macro which needs to convert 15 min intervals to 30 min Original data looks like <tbody> 00:00 2 3 5 00:15 2 1 4 00:30 5 2 6 00:45 5 3 4 01:00 7 4 2 01:15 7 2 3 </tbody> and I would need such an outcome somewhere right or left from the original <tbody>...

Hello wizards, I have a worksheet that has five data points entered for up to 15 different test locations on an item. I need to filter out the min and max value data point from each of the sets of five data points and retain the other three data points for each testing location (for...

How can I get the minimum value between 2 dates? Thank you MM