View Single Post
Old 08-20-2011, 12:06 AM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road

Another frequent error is about using "$". Focus on understanding this issue, and your problem is solved

if you use this formula, =H3="yes" , and you want that all columns in this row to depend on column H, you have to lock the column in your formula, otherwise , excel will evaluate the next column formula as : =I3="yes", the next column as =J3="yes", and so on.
Try: =$H3="yes", and excel will evaluate all columns involved in your range depending only for the value in column H.
Reply With Quote