Mixed reference copying
Which formula keeps column A fixed when copied across and allows the row number to change when copied down?
=$A2=A$2=$A$2=A2
Which formula keeps column A fixed when copied across and allows the row number to change when copied down?
=$A2=A$2=$A$2=A2