I have column A & B. In column C I have =iff(a1=b1,"Y","N"). Now I drag
that down column c to the bottom of the list. I might have
=iff(a150=b150,"Y","N"). Now I want to change a(row number) to a$(row
number) and b(row number) to b$(row number) for the whole column. I know I
can go cell by cell and click on the function at the top and hit f4, but if I
got hundres of rows that's a lot. And I can't make the rows absolute before
draging down, that would keep it the same row. Is there a quick and easy way
to do this?