Results 1 to 5 of 5

Find first cell with value greater than zero?

Threaded View

  1. #1
    Registered User
    Join Date
    09-22-2017
    Location
    Ontario, Canada
    MS-Off Ver
    2010
    Posts
    2

    Smile Find first cell with value greater than zero?

    Hi Everyone

    I am trying to look at over 5K rows of Gross Sales by year and month for 5yrs with of data. I need to determine the first incidence of any sales.

    REQUEST:I need a way of evaluating each row of data to...
    1) find the first cell which has a Gross Sales value greater than 1,
    2) then return the year and month in which these sales occurred. located in row15 as the header row
    3) Then find the last cell which has a value not equal to zero, this can be positive of negative value.
    4) then return the year and month in which the last sales occurred. located in row15 as the header row.

    My suspicions are it is Index & Match function but I have tried a couple thing with lackluster results.

    Thanks
    EF_007 :
    Attached Files Attached Files
    Last edited by Excel_Freak_007; 09-26-2017 at 09:38 AM. Reason: Adding File

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find a cell greater than another cell
    By timmtamm in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-27-2017, 01:11 AM
  2. Replies: 4
    Last Post: 12-09-2016, 12:54 PM
  3. find the last cell with a value greater than 0
    By stevekirk in forum Excel General
    Replies: 15
    Last Post: 10-30-2016, 01:55 AM
  4. [SOLVED] How to find first cell in range greater than X, if there is such a cell?
    By hadamhiram in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-23-2015, 12:48 PM
  5. [SOLVED] find value which is greater than in a range of cells and return the greater value
    By green369 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2015, 02:46 AM
  6. [SOLVED] Find first cell greater than 0 THEN calculate average and std from that cell to the end
    By jksung5295 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-21-2013, 12:30 PM
  7. Find cells with value greater than value of other cell+1
    By kcho in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 04-19-2013, 08:47 PM

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