If statement is driving me crazy

Hi All,

I am trying to create a formula that will populate as follows:
If the first cell of a row set is equal to "Y" then fill in all the other cells in the same row set to "Y". If the row set changes and the top row does not equal "Y" then leave as is. I have attached an example to this post.

I need to fill out a spreadsheet that is 1000s of rows and I am hoping I can just get excel do the work for me.

All of my attempts create circular references.

Any insight anyone might be able to provide would be greatly appreciated!

Thank you!

Hi FDibbins,

I'm afraid I tried your suggestion and received a circular reference warning. Are you able to upload your file so I can see the formula in a sheet?

Please let me know.

Thank you!

Sorry, I was copying into M2 when I needed to copy into M3. You are a life saver!

Your help is much appreciated!!!

Seriously lol!