|Just FYI (and you may know this already)...|
Depending on how/where you are using the formula, you may not need the A2 in the ROW function.
=ROW() will return the row number of the Row that the function is used in.
e.g. =ROW() used anywhere in Row 3 will return 3.
Therefore =ROW()+1 or =ROW()-4 can be used to offset the value returned by ROW() to match your needs. Obviously, as you drag that down, the ROW() function itself will increment so the final result will increment also.
That may not make much difference in this case, but the "offset syntax" can be helpful in other situations, such as when you might want to specify a Row based on a calculation in another cell:
=ROW()+A4 where A4 contains the offset value.
=ROW()-VLOOKUP(A1,$B$1:$C$10,2,0) where the VLOOKUP returns the offset value based on the lookup of A1.
Just tossing that out in case it can help.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03