max

Hi There, I'm working on my budget spreadsheet, i have a column of numbers generated by our budget formula. I want to add a formula in the next column that will adjust those number to a maximum of $35,000 a minimum of $10,000 and round up everything else to the nearest $100. It is possible to...

Hello, I use this formula to get the actual charge (AF19), Min Charge (AG19), Or max charge (AH19) by days of the month. Question is how do I keep the cell for say the June 2nd total blank without the min charge populating if the data is not filled in yet in the other cells to get the total...

I have a multi-tab spreadsheet that I want to extract the MIN and MAX values from the monthly tabs and transfer them to my "FL" tab. The code I use now does not allow for me to just drag the top value down to fill in all the cells in the columns. I think that "INDIRECT" might be what I'm looking...

Hi, I been looking all over the place for a solution. I created two macros one to highlight the duplicates and other one to filter on the highlighted ones. I have the result set with all the duplicates and I need to take the max of Col L if that column doesn't contain zero, if it does look at...

I'm revisiting my file and wondered if it's possible to tweak and to apply a minimum and maximum date. Basically, this is my data <tbody> PARTNO1 Hyundai Accent 01/01/94 31/12/99 PARTNO1 Hyundai i30 01/01/98 31/12/16 PARTNO1 Hyundai i40 01/01/99 31/12/17 PARTNO2 Hyundai Accent...

Is there a formula that knows the max number in the range and is able to then display the range of times corrosponding to the Max number within that row. For example, in the example below it would return 5:11-5:13 as those are the times where the value underneath is the highest in the row. And...

Hello, I'm wanting help with an IF statement. I am wanting to say If value in column G is equals or greater than the minimum (column C ) then 2750 until the value in column G is less than or equal to Max (column D) then 4000 =IF(ISBLANK(G3),"",IF(G3>=C3,2750,IF(G3<=D3,4000))) This is...

Hi all, i am new to this forum. I have tried functions index and match to fetch a value but could not get success. my query is : I have to match two columns and one row to fetch a value, but i am getting error. after using below function. for example: A50, 3X1.5X10, Mys Max===>569...

Morning, For the life of me i can not think of a way to do this. So im trying to set up a spreadsheet for inventory management. I have the following formula in cell E2 =IF([Average_Qty per week]>=3,[@[Average_Qty per week]]*D$1,(D$1/2)*[Average_Qty per week]) But i would like this to have...

have two sheets > SALES! & stocks! date & code in SALES!$C$6:$C$5088 & SALES!$E$6:$E$5088 respectively date out & item code in stocks!$C$59$:$C$1887 & stocks!F$59:$F$1887 respectively once item code scanned into SALES!$E$6:$E$5088 the current date will appear on stocks!$C$59$:$C$1887 with this...

Racking my brain on this one... creating a table of 1-10 buckets to show the average of values that fall in those buckets. The buckets are simply a min as the lowest, max as the highest, and the rest is equally distributed between the min and max. The issue is that when I also do a count of...

I would like a formula that I could lookup and return the latest date. There will be multiple matches, but only want the max one returned. I will have to do this for multiple lines and I have been unable to get Array formula's to work previously

Hi guys i have the below table: if i have a date in A1 i want to get the max time for that date. Thanks <tbody> date time 01/01/2019 18:45 01/01/2019 18:45 01/01/2019 18:45 01/01/2019 18:45 01/01/2019 18:45 02/01/2019 08:23 02/01/2019 08:23 03/01/2019 08:24 03/01/2019...

Hello I started a new job and I need help with my excel sheet. I have a column with dates. At the bottom I am using =MAX(F1660:F1680) to result the most recent date. Then I am using =DATEDIF(F1681,TODAY(),"D") to use the result of MAX date to count the number of days since the most recent date...

Hello, In the following example below I am trying to use a SUMIFS/MAX formula to get the total sum of a event minus the allowed amount of time for a event. When i try to use the formula below i get a sum of 0:00:00 instead of the actual value. Should i use a different formula completely or does...

Hello I tried many combinations of formulas but every time first and second highest value is the same im getting first key for both. DATA <tbody> # A B C 1 1 USER1 8 2 2 USER1 8 3 3 USER1 4 4 4 USER2 5 </tbody> Display <tbody> # A B 1 [find key [DATA A:A] of first highest value...

Hi, I want to find the maximum length of each field taking into account of errors that pop up. For example I have data in cells A2:B938, Column A is the ID number and Column B is a description, I am using the following formula to get the max length: {=MAX(LEN(A2:A938))} and similarly B2:B938...

I am trying to find the MAX date and time value in a column using VLOOKUP. Below is the code I have. I know it doesn't work. Can anyone shed some light?? =IF(K18="","",VLOOKUP(MAX(J17,J18:K114,2,FALSE))) Thank you for your support in advance.

Hi! I've a problem in DAX I can't solve. Perhaps you could help me... In an stock movement table, i have the next columns: Date-time, Product id, Movement id, Order id and Stock. The final stock value for each product is the number that appears in the column "Stock" in the last date-time and...

Hi, I have a work book with two sheets. On the Sheet1 I have a table with data for Restaurant in cells A1 to I4 Then I have data for Super market in cells A6 to I9 Finally I have data for Coffee shop in cells A11 to I14 <tbody> A B C D E F G H I 1 Restaurant Discount offer...