C
Cooldistribution
I am trying to program excel to return rows and values based on criteria and
need some help on which formula to use and how. I need a separate excel
document to add part numbers and qty whose sales are over a certain amount
for a given period of time. See below for example
Part# Description 1st Qtr Avg. 2nd Qtr Avg. 3rd Qtr Avg.
4th Qtr Avg
1 Float .67 .75
.38 1.45
I need the excel document to pull the part# description and qty if two
consecutive qtrs avg .67 and above and add it to a separate excel file.
need some help on which formula to use and how. I need a separate excel
document to add part numbers and qty whose sales are over a certain amount
for a given period of time. See below for example
Part# Description 1st Qtr Avg. 2nd Qtr Avg. 3rd Qtr Avg.
4th Qtr Avg
1 Float .67 .75
.38 1.45
I need the excel document to pull the part# description and qty if two
consecutive qtrs avg .67 and above and add it to a separate excel file.