min if; max if

  1. dss28

    Max IF function in vba

    i want to find the maximum value in column C corresponding to a value mentioned on Cell M1 of which data is given in Column B the code: max(if(B:B=M1,C:C) when written in one of the cells in the sheet with Ctrl+Shift+Enter gives the result correctly. however when applying the code in vba I am...
    • dss28
    • Thread
    • evaluate formula min if; max if vba & excel
    • Replies: 16
    • Forum: Excel Questions
  2. H

    Retrieve sequential numbers with multiple instances and alpha/numeric characters.

    I am trying top place a sequential value to my booth numbers by name. I am having issues when there are: 2 instances of non sequential numbers "example: KS GOLF KARTS, INC" 144-155 [Desired Result: 144-146 & 153-155] When there is an Alpha character in the numeric values "example: GARAGE...
  3. R

    Logical_test on Dates to get date_wise MIN and MAX values

    NEED HELP!!! I want to find the MIN and MAX from column 'values' with respect to dates. Data is in below format (each date has corresponding 1440 minutes and each minute has a specific value): Dates (several months; daily_basis) | Time (minute by minute) | Values (data) Required Result...
  4. BlondieC

    Using Min Max need to further identify odd even values to go in specific cells

    Starting with this code provided by a helpful person on here. WorksheetA and column A will be constant. I think I need a dynamic reference where WorksheetB is as there will be multiple worksheets that I want to pull the values from and the range on each of the worksheets will be the same...
  5. V

    Min IF & Max IF

    Good day to you all fellow Excel users I am having some sort of problem with function min if and max if. My function stands as As you can see in the picture, the formula does work on the Function Window. Giving me a min at the first row of 118.91. However, when I accept the function, it...

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