M

#### Monte Sliger

I have a worksheet (Sheet1) with the following column headings:

A B C

Date Description Amount

All data in this worksheet is arranged in date order.

I need to put a formula in a cell in another worksheet (Sheet2) which will

return the last value in column C where the corresponding data in column B

does not equal "Adjustment". For example my last five lines of data in

Sheet1 might consist of:

A B C

Date Description Amount

7/21/04 Sale -50.00

7/31/04 Adjustment 0.00

8/15/04 Purchase 25.00

8/31/04 Adjustment 1.00

9/30/04 Adjustment -1.00

I would need the formula to return the value 25.00 no matter how many

"Adjustment" lines there were either before or after the last line of data

in the list which did NOT have "Adjustment" in the description field.

Thanks for any help.

Monte Sliger