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


    Hello, Can you help me to analyze the formula in cell G4 please 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


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

Some videos you may like

This Week's Hot Topics