Bob,

Curiously the formula results change every time I edit a cell, any cell,

even if they are not in relation to the formula.

I think I know why but don't know how to fix it. The modified formula is

IN COLUMN G6

=IF(COUNTIF($C$6:$E$10,RIGHT(B6,2)+0),A6,"")

In "$C$6:$E$15" there are only numbers, no text

In "RIGHT(B6,2)+0".. "B6" column has numbers (from formulas) as well as dates

In "A6" column there are text and numbers.

Again, I didn't think

it would be a problem so I left out those details..

Sorry for that.

Here is a real sample of EXACTLY what I have.

A B C D E G

667 9/23/05 10 5 8

John 20 15 18

Since last 595 30 25 28

first out 40 35 38

days between 50 45 48

Running Total 595 60 65 58

5 1629 70 75 68

45 520 80 85 78 45

23 855 90 95 98

So in this example "45" is the only result that should be displayed in "G"

with out changing when I add data to other cells.

Is That Possible?

Thank You

Luke