"FIND" EXCEL FORMULA
Posted by Gordon on June 23, 2001 4:29 PM
I need a formula for excel '97.
In worksheet1, I have column A as "Totals" and column B as "Codes". "Totals" is a calculation of a data entry worksheet. I need to look at column A "Totals" to find values greather than 0. If the value is greater than 0, I need to pull that value along with the corresponding code from column B into my new worksheet. Does anyone have a formula that will do this? Please???