I'm currently using the following formula in Excel...

=IF(ISNUMBER(SEARCH("16 x 16",Sheet1!K2)),"Square", "Not Square")

I want to be able to copy this down thousands of rows but this results in 1 being added to K2 above each row whereas I need it to stay the same for an additional 10 rows before increasing to K3, and then a further 10 rows before increasing to K4 (etc).

Thanks in advance.