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 :
Bookmarks