You said the CF formula works when there is a $ in it.

The dollar sign means to always use that column (or row) for the comparison. It sounds like you want to use a different CF formula in other columns?

I'm not sure where you are with your question now.

I hope you understand the $ in the formula. If not a very simple explaination can be found at http://www.homeandlearn.co.uk/excel2...l2007s7p5.html