max/min

  1. M

    formulas with "NA"?

    Hi, I asked a similar question with the "SUM" function. Now I want to use Max and Min but the range will occasionally have "#N/A" in the data. I want the max/min to skip those cells. How do I construct this formula? Thanks
  2. D

    Max/min

    Hello, Can you help me to analyze the formula in cell G4 please https://www.dropbox.com/s/zodfwf08ima5w16/Excel.jpg?dl=0 Thank in advance
  3. J

    Determing Overlapping Time

    I am trying to determine the concurrent sessions, or time that is overlapped within PowerPivot or an Excel pivot for data set of sessions that have start and stop times (date:hour:min:sec). Column A contains the start times and column B contains the end times. Ideally, I would like to create a...
  4. J

    What IF's

    <TABLE style="WIDTH: 428pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=568 border=0 x:str><COLGROUP><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" span=4 width=74><COL...
  5. powerjak

    Using Index/Match to Find Values in Autofiltered Range Only

    I need some help with a problem I'm stuck on. I'd really appreciate anyone's help to resolve this quickly. I have a table consisting of 5-minute interval data for one (1) Month from an electric utility meter. I've set up an Autofilter to allow selecting just the samples associated with a...
  6. N

    MAXIMUM and MINIMUM FOR EACH DATE - VBA

    <TABLE class=tborder id=post1823843 cellSpacing=0 cellPadding=6 width="100%" align=center border=0><TBODY><TR vAlign=top><TD class=alt1 id=td_post_1823843 style="BORDER-RIGHT: #ffffff 1px solid">Hello Everyone, This will be my first post and I think everyones Genius here. Anyways I'm fairly new...

Watch MrExcel Video

This Week's Hot Topics

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
Top