View Single Post
 
Old 03-25-2012, 09:59 AM
MarvinP MarvinP is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Jan 2012
Location: Seattle, WA
Posts: 12
MarvinP is on a distinguished road
Default

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
Reply With Quote