J
jzachar
If I have several products in rows and the months of the year in the columns
(the data in the columns is the sales quantity for each month) and I want to
count over from the right to the 25th cell to see if that particular cell and
all the cell's to the 25th cell's left are blank...if this is true I want to
place an "x" in the formula cell.
Basically what this formula would do would tell me if the product is a
mature product or not. A mature product is categorized as having sales for
greater than 24 months and a new product is categorized as having sales only
within 24 months or less. My spreadsheet will have several years of data in
it by month.
thanks for the help in advance!!!!
Jeff
(the data in the columns is the sales quantity for each month) and I want to
count over from the right to the 25th cell to see if that particular cell and
all the cell's to the 25th cell's left are blank...if this is true I want to
place an "x" in the formula cell.
Basically what this formula would do would tell me if the product is a
mature product or not. A mature product is categorized as having sales for
greater than 24 months and a new product is categorized as having sales only
within 24 months or less. My spreadsheet will have several years of data in
it by month.
thanks for the help in advance!!!!
Jeff