"Relative Reference Issue"

**DonkeyOte** · 03-05-2009, 06:14 AM

Firstly, please rephrase your Q to something meaningful related to your question - perhaps "Relative Reference Issue"

Secondly, ROWS(C9:G9) will always be 1 as there is one row in the range... it strikes me you want to perhaps think about switching to COLUMNS or rewriting:

=IF(COUNTIF(C9:G9,"<>x"),"Not ","")&"Complete"

**smj276** · 03-05-2009, 05:31 PM

Thanks heaps.

I was way off the mark but it's all good now
Cheers
Shane

**VBA Noob** · 03-05-2009, 05:33 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save