+ Reply to Thread
Results 1 to 3 of 3

Find first cell greater than 0 THEN calculate average and std from that cell to the end

  1. #1
    Registered User
    Join Date
    06-17-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    9

    Find first cell greater than 0 THEN calculate average and std from that cell to the end

    I couldn't figure out how to complete this task. I looked around and all the formulas that i have seen only return the value of the that not necessarily the address.

    Here is what i'm trying to do
    1. Find the first cell with a value higher than "0"
    2. Then use that cell address as a starting point for the "average" and "standard deviation" calculations

    I have attached a file as to what I would like to do.
    Column G should return the address of the first cell with value higher than 0. Then column H and I uses the column G value to calculate.

    Thank you so much for all your help!
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Find first cell greater than 0 THEN calculate average and std from that cell to the en

    In row 2

    Average
    =AVERAGE(INDEX(B2:F2,MATCH(TRUE,INDEX(B2:F2>0,0),0)):F2)

    Stdev
    =STDEV(INDEX(B2:F2,MATCH(TRUE,INDEX(B2:F2>0,0),0)):F2)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    06-17-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Find first cell greater than 0 THEN calculate average and std from that cell to the en

    OMFG! That is just freaking awesome! Thank you SO MUCH! you saved so much time for me!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1