Subdividing a huge spreadsheet into groups of 200 rows

[leimst]

Good evening,

Surely the answer to this question is already posted out there somewhere and I am just phrasing my "search" incorrectly.

Anyway, I have a spreadsheet with over 37,000 rows and want to insert a column where the first 200 rows read "P1" in column A, the second 200 reads "P2", the thirds 200 reads "P3", etc. all the way down to the bottom of the 37,000 rows where it would end with "P185".

Thanks all for any help,

Brian

 

[NARAYANK991]

Hi Brian ,

Try this :

="P" & INT((ROW()-1)/200)+1

Narayan

 

[leimst]

Brilliant and elegantly simple! Thank you Narayank991!!!