Results 1 to 3 of 3

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

Threaded View

  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

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