Excel every 25th row

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I have over 7,000 rows and I need to find every 25th one and don't want to hand count. Is there a way to sort or is there a formula to find every 25th row. So it would be the 25th, 50th, 75th, 100th, 125th...and so on row.

Thanks!


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
What exactly you mean by find 25th rows

If you want some sort of flag you can use the formula

On the first row of a column you will write
=IF(MOD(ROW(),25)=0, "Yes", "No")

then drag the formula down to the last row. Every 25th row will have a yes