Search

[ISABELLA CRISTINO]

Hi,

I would like to search for the term"2008" on Excel but only on the "F" cell of the documment, but i don't know how to do that.

[#2]

On a different column from F (let's say A1): =COUNTIF(F:F;2008) This gives you 0 if there are no 2008 in column F, or the number of 2008 in all F. If you want, you can change 2008 with a cell (let's say B1) resulting =COUNTIF(F:F;B1) and it will count anything you insert in the B1 cell.