max

  1. S

    Min, max, question

    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...
  2. R

    Min and Max Values on Separate Tab

    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...
  3. R

    Duplicate cells on col A and looking at another Column and taking the max of the another column if that col doesn't have zeros

    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...
  4. S

    Lowest and Highest Date based on value in another column

    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...
  5. Y

    Formula displaying max ranges?

    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...
  6. H

    If statement until..

    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...
  7. B

    index with match function -two columns and one row

    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...
  8. T

    Formula to Multiply by a cell value

    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...
  9. C

    Getting the latest date

    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...
  10. ExcelChampion

    Creating Bins based on Average Value *AND* Count

    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...
  11. M

    Return MAX result for specific criteria for multiple values

    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
  12. R

    max time for date

    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...
  13. L

    IF ELSE Usage

    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...
  14. S

    Sumifs/MAX formula Fix

    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...
  15. D

    Find two highest values and index (even value is the same)

    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...
  16. tyija1995

    Max Length of a field with Errors

    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...
  17. J

    VLOOKUP Max Find

    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.
  18. B

    Doble condition

    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...
  19. P

    A question about IF 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...
  20. R

    MAXIF on dates

    I searched through the many MAXIF posts and can not find a solution to my problem. Lets say I have a two column list, first column is date and second column is quantity. What I am looking for if the maximum value from a particular year. I tried =MAX(IF(YEAR(A2:A12)=2017,B2:B12)) but it returns...

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