Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |