max/min

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

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

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

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

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

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